In [1]:
import pandas as pd
import matplotlib.pyplot as plt
import matplotlib as mpl
import numpy as np
from pathlib import Path
from wordcloud import WordCloud, STOPWORDS
from datetime import datetime
In [2]:
raw = Path('/home3/usfb/analysis/analysis-fake-news/input/reaction/1000-page/20-min/by-reaction-type/LIKE/by-page-id')
page_info_path = Path('/home3/usfb/build/output/page/1000-page-info.csv')
politifact_fake_domain_path = Path('/home3/usfb/analysis/analysis-fake-news/temp/post-match-domain/1000_page_politifact_domain.csv')
all_post_path = Path('/home3/usfb/analysis/analysis-fake-news/input/post/1000-page/2015-01-01-to-2017-04-08.csv')
In [4]:
all_post = pd.read_csv(all_post_path)
all_post
Out[4]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_likes post_comments post_shares post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count
0 5.444446e+10 WTHR-TV 54444461143_10153245342666144 photo NaN WTHR is wishing a very happy birthday to John ... NaN https://scontent.xx.fbcdn.net/hphotos-xpf1/v/t... https://www.facebook.com/WTHR13/photos/a.12486... NaN ... 3920739.0 97206.0 1521964.0 2015-07-25T20:35:12Z 2015-07-27T17:40:46Z 2015-07-25 2015-07-27 2015-07-26T01:35:12Z 2015-07-27T22:40:46Z 165048.0
1 2.637436e+11 9NEWS (KUSA) 263743636076_10152822691401077 video NaN Thank you. Welcome home. NaN https://scontent.xx.fbcdn.net/v/t15.0-10/s130x... https://www.facebook.com/ilike9news/videos/101... NaN ... 1761230.0 76471.0 2312763.0 2014-12-31T19:49:38Z 2017-05-21T10:31:11Z 2014-12-31 2017-05-21 2015-01-01T01:49:38Z 2017-05-21T15:31:11Z 128078.0
2 1.143646e+14 ForAmerica 114364638621903_890023284389364 photo Timeline Photos Christian country singer Carrie Underwood is u... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/ForAmerica/photos/a.1... NaN ... 1639908.0 41595.0 146719.0 2015-01-11T18:00:00Z 2017-05-16T07:19:49Z 2015-01-11 2017-05-16 2015-01-12T00:00:00Z 2017-05-16T12:19:49Z 225676.0
3 2.178595e+10 9GAG 21785951839_10154491127201840 photo Timeline Photos This is why his speech was soooo fluent! Congr... NaN https://scontent.xx.fbcdn.net/hphotos-xlf1/v/t... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1626598.0 16615.0 161393.0 2016-02-28T23:16:57Z 2016-02-28T23:16:57Z 2016-02-28 2016-02-28 2016-02-29T05:16:57Z 2016-02-29T05:16:57Z 3842818.0
4 3.896583e+14 Right Wing News 389658314427637_956582867735176 photo Timeline Photos NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/OfficialRightWingNews... NaN ... 1574853.0 14681.0 154392.0 2015-01-18T23:00:01Z 2017-01-22T06:50:03Z 2015-01-18 2017-01-22 2015-01-19T05:00:01Z 2017-01-22T12:50:03Z 402776.0
5 2.189830e+10 BuzzFeed 21898300328_10155291462855329 video NaN Who Will Win: Dog Or Cat?\n\nVote "Like" For D... NaN https://scontent.xx.fbcdn.net/v/t15.0-10/p130x... https://www.facebook.com/BuzzFeed/videos/10155... NaN ... 1550521.0 151062.0 49378.0 2016-11-07T13:50:55Z 2016-11-09T12:31:10Z 2016-11-07 2016-11-09 2016-11-07T19:50:55Z 2016-11-09T18:31:10Z 6353190.0
6 5.550297e+09 CNN 5550296508_10155640542156509 video Ellen DeGeneres holds back tears as she receiv... "Just keep swimming": An emotional Ellen DeGen... NaN https://scontent.xx.fbcdn.net/v/t15.0-10/p130x... https://www.facebook.com/cnn/videos/1015564054... NaN ... 1503501.0 68867.0 859761.0 2016-11-22T18:31:01Z 2017-04-08T14:57:05Z 2016-11-22 2017-04-08 2016-11-23T00:31:01Z 2017-04-08T19:57:05Z 3754033.0
7 5.294696e+10 B. Scott 52946962893_10152995060277894 photo NaN 1st gay couple to be married in Dallas. George... NaN https://scontent.xx.fbcdn.net/hphotos-xpt1/v/t... https://www.facebook.com/lovebscott/photos/a.1... NaN ... 1475642.0 31505.0 205445.0 2015-06-26T17:17:10Z 2015-06-26T17:17:10Z 2015-06-26 2015-06-26 2015-06-26T22:17:10Z 2015-06-26T22:17:10Z 1266661.0
8 2.178595e+10 9GAG 21785951839_10153133208006840 photo Timeline Photos Best group selfie award goes to...\nhttp://9ga... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1423955.0 12109.0 37839.0 2015-01-18T23:15:01Z 2017-04-24T21:44:15Z 2015-01-18 2017-04-24 2015-01-19T05:15:01Z 2017-04-25T02:44:15Z 7968743.0
9 2.178595e+10 9GAG 21785951839_10153454504186840 photo Timeline Photos Gotta be a Melon Lord!\nhttp://9gag.com/gag/av... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1409380.0 73936.0 701526.0 2015-05-02T10:15:01Z 2017-05-21T04:44:10Z 2015-05-02 2017-05-21 2015-05-02T15:15:01Z 2017-05-21T09:44:10Z 7968743.0
10 5.930662e+10 Good Morning America 59306617060_10154315710532061 video NaN WATCH: Fifth grade English teacher in North Ca... NaN https://scontent.xx.fbcdn.net/v/t15.0-10/s130x... https://www.facebook.com/GoodMorningAmerica/vi... NaN ... 1337324.0 133008.0 2612700.0 2017-02-01T15:00:55Z 2017-04-09T11:46:05Z 2017-02-01 2017-04-09 2017-02-01T21:00:55Z 2017-04-09T16:46:05Z 1105102.0
11 2.178595e+10 9GAG 21785951839_10154402731186840 photo Timeline Photos R.I.P To this legend, Alan Rickman. You are fo... NaN https://scontent.xx.fbcdn.net/hphotos-xaf1/v/t... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1202113.0 25804.0 548286.0 2016-01-14T07:09:04Z 2016-01-15T02:00:58Z 2016-01-14 2016-01-15 2016-01-14T13:09:04Z 2016-01-15T08:00:58Z 9060512.0
12 3.173248e+10 The Tonight Show Starring Jimmy Fallon 31732483895_10154764200303896 video Jimmy Fallon, Metallica & The Roots Sing "Ente... Metallica joins Jimmy and The Roots in the Ton... NaN https://scontent.xx.fbcdn.net/v/t15.0-10/s130x... https://www.facebook.com/FallonTonight/videos/... NaN ... 1168518.0 153979.0 2628065.0 2016-11-16T22:48:54Z 2017-05-26T11:23:47Z 2016-11-16 2017-05-26 2016-11-17T04:48:54Z 2017-05-26T16:23:47Z 722158.0
13 5.550297e+09 CNN 5550296508_10153610013316509 photo Photos from CNN's post At least 22 hours after the earthquake struck ... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/cnn/photos/a.36981009... NaN ... 1152981.0 37413.0 306264.0 2015-04-29T09:31:00Z 2017-05-04T15:57:55Z 2015-04-29 2017-05-04 2015-04-29T14:31:00Z 2017-05-04T20:57:55Z 2474432.0
14 2.178595e+10 9GAG 21785951839_10155113971791840 link Official White House Photographer Reveals His ... Obama is the coolest president in history. �� ... 9gag.com https://external.xx.fbcdn.net/safe_image.php?d... http://9gag.com/gag/ajqEV90?ref=fbp Click to see the pic and write a comment... ... 1149630.0 20093.0 209506.0 2016-11-11T07:35:00Z 2017-03-16T04:05:56Z 2016-11-11 2017-03-16 2016-11-11T13:35:00Z 2017-03-16T09:05:56Z 8425994.0
15 4.066771e+10 Kirk Cameron 40667713734_10153486239323735 photo Mobile Uploads I was only 20 years old when I married the lov... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/kirkcameron/photos/a.... NaN ... 1144361.0 36312.0 25165.0 2015-07-20T23:50:45Z 2017-05-19T20:35:47Z 2015-07-20 2017-05-19 2015-07-21T04:50:45Z 2017-05-20T01:35:47Z 28714.0
16 3.469371e+14 Occupy Democrats 346937065399354_1182822125144173 video Racism DESTROYED in one minute EPIC. Racism DESTROYED in one minute. A must-s... NaN https://scontent.xx.fbcdn.net/v/t15.0-10/p130x... https://www.facebook.com/OccupyDemocrats/video... NaN ... 1141561.0 54773.0 2651231.0 2016-07-13T15:29:25Z 2017-05-01T08:04:41Z 2016-07-13 2017-05-01 2016-07-13T20:29:25Z 2017-05-01T13:04:41Z 1906140.0
17 1.299302e+11 Michael Baisden Live 129930197818_10152794487597819 photo Timeline Photos POW! NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/michaelbaisdenlive/ph... NaN ... 1137246.0 74239.0 3688873.0 2015-01-06T19:00:01Z 2017-05-22T02:42:40Z 2015-01-06 2017-05-22 2015-01-07T01:00:01Z 2017-05-22T07:42:40Z 735369.0
18 9.208540e+09 Demi Lovato 9208539755_10153141114079756 photo Timeline Photos ❤️��☀️���� NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/DemiLovato/photos/a.5... NaN ... 1136173.0 12258.0 11969.0 2015-02-05T17:56:47Z 2017-05-29T11:53:13Z 2015-02-05 2017-05-29 2015-02-05T23:56:47Z 2017-05-29T16:53:13Z 163730.0
19 2.215686e+10 Explore Talent - Acting and Modeling 22156858944_10153356533903945 photo Mobile Uploads I don't care how old I am, I need these super ... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/ExploreTalent/photos/... NaN ... 1128827.0 135242.0 762909.0 2015-05-16T17:35:09Z 2017-04-30T13:39:21Z 2015-05-16 2017-04-30 2015-05-16T22:35:09Z 2017-04-30T18:39:21Z 407574.0
20 9.971081e+14 Anonymous 997108126967413_1274543885890501 video NaN Wow! .. NaN https://scontent.xx.fbcdn.net/v/t15.0-10/p130x... https://www.facebook.com/anonews.co/videos/127... NaN ... 1127359.0 54935.0 3099951.0 2016-07-15T17:29:18Z 2017-05-26T07:48:36Z 2016-07-15 2017-05-26 2016-07-15T22:29:18Z 2017-05-26T12:48:36Z 3867108.0
21 2.178595e+10 9GAG 21785951839_10153379859131840 photo Timeline Photos The sad truth.\nhttp://9gag.com/gag/ae0VRRv?re... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1118145.0 9614.0 144791.0 2015-04-10T23:00:01Z 2017-04-12T06:24:12Z 2015-04-10 2017-04-12 2015-04-11T04:00:01Z 2017-04-12T11:24:12Z 7910688.0
22 1.386911e+14 Dr. Ben Carson 138691142964027_536365619863242 photo Timeline Photos Yes, #IamaChristian. NaN https://scontent.xx.fbcdn.net/hphotos-xpt1/v/t... https://www.facebook.com/realbencarson/photos/... NaN ... 1093592.0 30533.0 169234.0 2015-10-02T15:29:24Z 2015-10-04T13:41:24Z 2015-10-02 2015-10-04 2015-10-02T20:29:24Z 2015-10-04T18:41:24Z 844845.0
23 1.894310e+10 Lizzy the Lezzy 18943096862_10152566189746863 photo Timeline Photos exactly! <3\npic: @mannymua733 on instagram NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/LizzyTheLezzy/photos/... NaN ... 1075415.0 55756.0 220277.0 2015-01-21T13:33:00Z 2017-05-22T01:08:44Z 2015-01-21 2017-05-22 2015-01-21T19:33:00Z 2017-05-22T06:08:44Z 388481.0
24 1.570455e+10 Fox News 15704546335_10154481813316336 photo Timeline Photos Chris Kyle's hometown of Odessa, Texas unveile... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/FoxNews/photos/a.1840... NaN ... 1050218.0 17016.0 207970.0 2016-07-28T17:06:25Z 2016-07-30T08:34:40Z 2016-07-28 2016-07-30 2016-07-28T22:06:25Z 2016-07-30T13:34:40Z 4738330.0
25 2.178595e+10 9GAG 21785951839_10154380654711840 photo Timeline Photos Just... be like John. Please.\nhttp://9gag.com... NaN https://scontent.xx.fbcdn.net/hphotos-xta1/v/t... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1050167.0 44180.0 154902.0 2016-01-07T05:37:06Z 2016-01-09T00:27:42Z 2016-01-07 2016-01-09 2016-01-07T11:37:06Z 2016-01-09T06:27:42Z 8766863.0
26 9.124188e+09 U.S. Senator Bernie Sanders 9124187907_10155563196822908 photo Timeline Photos President Trump, you have made a big mistake. ... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/senatorsanders/photos... NaN ... 1045218.0 45684.0 296174.0 2017-01-21T16:05:51Z 2017-04-08T12:46:14Z 2017-01-21 2017-04-08 2017-01-21T22:05:51Z 2017-04-08T17:46:14Z 1061986.0
27 1.990986e+14 LADbible 199098633470668_1520999951280523 photo Timeline Photos Respect! NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/LADbible/photos/a.200... NaN ... 1037533.0 10887.0 97346.0 2015-03-17T13:48:39Z 2017-05-17T18:34:30Z 2015-03-17 2017-05-17 2015-03-17T18:48:39Z 2017-05-17T23:34:30Z 15016627.0
28 1.894310e+10 Lizzy the Lezzy 18943096862_10152524038346863 photo Timeline Photos right! ;) NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/LizzyTheLezzy/photos/... NaN ... 1031849.0 39956.0 172983.0 2015-01-04T13:35:02Z 2017-03-30T04:47:01Z 2015-01-04 2017-03-30 2015-01-04T19:35:02Z 2017-03-30T09:47:01Z 399563.0
29 2.178595e+10 9GAG 21785951839_10154279876181840 photo Timeline Photos This is only the first lesson, boy!\nhttp://9g... NaN https://scontent.xx.fbcdn.net/hphotos-xpl1/v/t... https://www.facebook.com/9gag/photos/a.1090410... NaN ... 1031648.0 33687.0 264878.0 2015-12-05T05:30:00Z 2015-12-07T02:01:10Z 2015-12-05 2015-12-07 2015-12-05T11:30:00Z 2015-12-07T08:01:10Z 7499142.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
14747916 1.972120e+11 Boston Herald 197211981599_10154773904451600 photo Boston Herald's cover photo President-elect Donald Trump pumps his fist du... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/bostonherald/photos/a... NaN ... NaN NaN 2.0 2016-11-09T11:00:30Z 2016-11-09T16:52:16Z 2016-11-09 2016-11-09 2016-11-09T17:00:30Z 2016-11-09T22:52:16Z 0.0
14747917 6.619786e+10 FOX5 Las Vegas 66197856671_10154671861186672 photo FOX5 Las Vegas's cover photo Trump to win Utah (6) NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 7.0 2016-11-08T22:18:33Z 2016-11-09T09:37:02Z 2016-11-08 2016-11-09 2016-11-09T04:18:33Z 2016-11-09T15:37:02Z 59491.0
14747918 3.207724e+14 Red State Dems 320772408017742_837102216384756 photo Red State Dems NaN NaN https://scontent.xx.fbcdn.net/hphotos-xfa1/v/t... https://www.facebook.com/RedStateDems/photos/a... NaN ... NaN NaN 4.0 2015-06-26T09:32:07Z 2015-06-26T09:32:07Z 2015-06-26 2015-06-26 2015-06-26T14:32:07Z 2015-06-26T14:32:07Z 1528.0
14747919 4.232416e+10 BET 42324160403_10152853824045404 photo BET NaN NaN https://scontent.xx.fbcdn.net/hphotos-xat1/v/t... https://www.facebook.com/BET/photos/a.42534183... NaN ... NaN NaN 914.0 2015-06-26T14:34:26Z 2015-06-28T11:18:54Z 2015-06-26 2015-06-28 2015-06-26T19:34:26Z 2015-06-28T16:18:54Z 462623.0
14747920 2.776131e+14 Mint Press News 277613075615568_259207930786056 link The Conscious Resistance Network NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-1/p130x13... https://www.facebook.com/TheConsciousResistance/ You Are Powerful.\nYou Are Beautiful.\nYou Are... ... NaN NaN NaN 2016-10-31T11:54:35Z 2016-10-31T11:54:35Z 2016-10-31 2016-10-31 2016-10-31T16:54:35Z 2016-10-31T16:54:35Z 133538.0
14747921 9.066295e+10 WTAE-TV Pittsburgh 90662953642_10153696765683643 photo NaN It's DAY 1 of our WHERE'S ELLEN contest! \n\nR... NaN https://scontent.xx.fbcdn.net/hphotos-xfp1/v/t... https://www.facebook.com/wtae4/photos/a.381577... NaN ... NaN NaN 36.0 2015-08-17T07:00:00Z 2015-08-19T04:55:51Z 2015-08-17 2015-08-19 2015-08-17T12:00:00Z 2015-08-19T09:55:51Z 57003.0
14747922 6.619786e+10 FOX5 Las Vegas 66197856671_10154672229751672 photo FOX5 Las Vegas's cover photo Donald Trump Wins Presidency. NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 107.0 2016-11-09T01:40:40Z 2016-11-09T10:44:41Z 2016-11-09 2016-11-09 2016-11-09T07:40:40Z 2016-11-09T16:44:41Z 59491.0
14747923 1.972120e+11 Boston Herald 197211981599_10153533133401600 photo Boston Herald NaN NaN https://scontent.xx.fbcdn.net/hphotos-xft1/v/t... https://www.facebook.com/bostonherald/photos/a... NaN ... NaN NaN 1.0 2015-07-26T09:28:16Z 2015-07-26T09:28:16Z 2015-07-26 2015-07-26 2015-07-26T14:28:16Z 2015-07-26T14:28:16Z 11643.0
14747924 1.845999e+14 Women's Rights News 184599864915751_1316941335014926 photo Women's Rights News's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/WOMENSRIGHTSNEWS/phot... NaN ... NaN NaN 53.0 2016-11-07T16:52:47Z 2016-11-08T17:06:17Z 2016-11-07 2016-11-08 2016-11-07T22:52:47Z 2016-11-08T23:06:17Z 308765.0
14747925 6.619786e+10 FOX5 Las Vegas 66197856671_10154671708581672 photo FOX5 Las Vegas's cover photo FOX projecting Clinton wins NM and Trump takes... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 10.0 2016-11-08T20:53:52Z 2016-11-08T20:59:12Z 2016-11-08 2016-11-08 2016-11-09T02:53:52Z 2016-11-09T02:59:12Z 59491.0
14747926 1.666224e+14 Gay Star News 166622430080749_1201774873232161 photo Gay Star News's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/GayStarNews/photos/a.... NaN ... NaN NaN 7.0 2016-11-23T03:51:04Z 2016-11-24T01:08:25Z 2016-11-23 2016-11-24 2016-11-23T09:51:04Z 2016-11-24T07:08:25Z 158494.0
14747927 7.292472e+10 ABC News 72924719987_10155644933634988 photo ABC News's cover photo A man from the Taroko tribe in Taiwan is recor... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/abcnews.au/photos/a.1... NaN ... NaN NaN 10.0 2016-10-23T13:57:22Z 2016-10-24T04:45:05Z 2016-10-23 2016-10-24 2016-10-23T18:57:22Z 2016-10-24T09:45:05Z 282539.0
14747928 7.356330e+10 The Situation Room 73563300980_10152904397015981 photo The Situation Room NaN NaN https://scontent.xx.fbcdn.net/hphotos-xpf1/v/t... https://www.facebook.com/CNNSituationRoom/phot... NaN ... NaN NaN 3.0 2015-07-29T11:51:50Z 2015-07-29T17:14:34Z 2015-07-29 2015-07-29 2015-07-29T16:51:50Z 2015-07-29T22:14:34Z 38154.0
14747929 6.619786e+10 FOX5 Las Vegas 66197856671_10154671903121672 photo FOX5 Las Vegas's cover photo Georgia (16) to Trump NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 56.0 2016-11-08T22:42:03Z 2016-11-08T23:31:57Z 2016-11-08 2016-11-08 2016-11-09T04:42:03Z 2016-11-09T05:31:57Z 59491.0
14747930 1.675294e+14 Living Blue in Texas 167529403402369_631739320314706 link Hillary Clinton NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-1/p130x13... https://www.facebook.com/hillaryclinton/ Wife, mom, grandma, women+kids advocate, FLOTU... ... NaN 0.0 NaN 2016-07-14T09:46:13Z 2016-07-14T09:46:13Z 2016-07-14 2016-07-14 2016-07-14T14:46:13Z 2016-07-14T14:46:13Z 24532.0
14747931 4.232416e+10 BET 42324160403_10153748914570404 photo BET Tune in on Saturday, September 10 @ 8P/7C to w... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/BET/photos/a.42534183... NaN ... NaN NaN 7935.0 2016-09-08T23:40:15Z 2016-09-10T23:24:26Z 2016-09-08 2016-09-10 2016-09-09T04:40:15Z 2016-09-11T04:24:26Z 461384.0
14747932 6.619786e+10 FOX5 Las Vegas 66197856671_10154671673146672 photo FOX5 Las Vegas's cover photo Update NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 19.0 2016-11-08T20:33:48Z 2016-11-08T20:48:14Z 2016-11-08 2016-11-08 2016-11-09T02:33:48Z 2016-11-09T02:48:14Z 59491.0
14747933 6.619786e+10 FOX5 Las Vegas 66197856671_10154670251276672 photo FOX5 Las Vegas's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN NaN 2016-11-08T11:15:11Z 2016-11-08T11:15:11Z 2016-11-08 2016-11-08 2016-11-08T17:15:11Z 2016-11-08T17:15:11Z 59491.0
14747934 8.860326e+09 Financial Times 8860325749_10154640990825750 photo Financial Times's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/financialtimes/photos... NaN ... NaN NaN 8.0 2016-11-07T12:09:59Z 2016-11-09T05:38:22Z 2016-11-07 2016-11-09 2016-11-07T18:09:59Z 2016-11-09T11:38:22Z 90683.0
14747935 1.972120e+11 Boston Herald 197211981599_10154638410351600 photo Boston Herald NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/bostonherald/photos/a... NaN ... NaN NaN 2.0 2016-09-29T03:26:39Z 2016-09-29T03:26:39Z 2016-09-29 2016-09-29 2016-09-29T08:26:39Z 2016-09-29T08:26:39Z 6167.0
14747936 1.972120e+11 Boston Herald 197211981599_10154617979541600 photo Boston Herald NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/bostonherald/photos/a... NaN ... NaN NaN 1.0 2016-09-22T05:09:28Z 2016-09-22T05:09:28Z 2016-09-22 2016-09-22 2016-09-22T10:09:28Z 2016-09-22T10:09:28Z 14179.0
14747937 6.619786e+10 FOX5 Las Vegas 66197856671_10154672100621672 photo FOX5 Las Vegas's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 12.0 2016-11-09T00:27:32Z 2016-11-09T01:19:52Z 2016-11-09 2016-11-09 2016-11-09T06:27:32Z 2016-11-09T07:19:52Z 59491.0
14747938 1.283341e+14 Todd Starnes 128334087241432_885356888205811 photo Todd Starnes NaN NaN https://scontent.xx.fbcdn.net/hphotos-xpa1/v/t... https://www.facebook.com/ToddStarnesFNC/photos... NaN ... NaN NaN 625.0 2015-07-31T12:38:47Z 2015-07-31T19:26:51Z 2015-07-31 2015-07-31 2015-07-31T17:38:47Z 2015-08-01T00:26:51Z 115463.0
14747939 3.708703e+11 Fox Carolina News 370870329165_10154685674009166 photo Fox Carolina News's cover photo Nicole Papay has the weather updates you need ... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/foxcarolinanews/photo... NaN ... NaN NaN NaN 2016-11-10T14:03:08Z 2016-11-10T14:09:58Z 2016-11-10 2016-11-10 2016-11-10T20:03:08Z 2016-11-10T20:09:58Z 163816.0
14747940 1.972120e+11 Boston Herald 197211981599_10154627021391600 photo Boston Herald NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/bostonherald/photos/a... NaN ... NaN NaN 3.0 2016-09-25T06:15:19Z 2016-09-25T14:39:52Z 2016-09-25 2016-09-25 2016-09-25T11:15:19Z 2016-09-25T19:39:52Z 10144.0
14747941 9.322870e+10 Tea Party Patriots 93228695778_10153138169185779 photo Timeline Photos Illegal immigration has reached crisis proport... NaN https://scontent.xx.fbcdn.net/hphotos-xaf1/v/t... https://www.facebook.com/teapartypatriots/phot... NaN ... NaN NaN 764.0 2015-10-31T20:00:00Z 2015-11-01T08:41:53Z 2015-10-31 2015-11-01 2015-11-01T01:00:00Z 2015-11-01T14:41:53Z 249979.0
14747942 2.094664e+10 The Dallas Morning News 20946638799_10154295760903800 photo The Dallas Morning News's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/dallasmorningnews/pho... NaN ... NaN NaN NaN 2016-11-07T17:55:22Z 2016-11-09T02:21:54Z 2016-11-07 2016-11-09 2016-11-07T23:55:22Z 2016-11-09T08:21:54Z 52776.0
14747943 6.619786e+10 FOX5 Las Vegas 66197856671_10154671493721672 photo FOX5 Las Vegas's cover photo #NVELECTIONHQ FOX5 brings you the latest elec... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN 5.0 2016-11-08T19:31:37Z 2016-11-08T19:34:43Z 2016-11-08 2016-11-08 2016-11-09T01:31:37Z 2016-11-09T01:34:43Z 59491.0
14747944 6.619786e+10 FOX5 Las Vegas 66197856671_10154664933961672 photo FOX5 Las Vegas's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/FOX5Vegas/photos/a.10... NaN ... NaN NaN NaN 2016-11-06T15:59:42Z 2016-11-06T15:59:42Z 2016-11-06 2016-11-06 2016-11-06T21:59:42Z 2016-11-06T21:59:42Z 60144.0
14747945 4.291015e+14 Meme GOP 429101477109798_1298414466845157 photo Meme GOP NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/MemeGOP/photos/a.4291... NaN ... NaN NaN 3.0 2016-09-20T09:52:15Z 2016-09-20T23:53:38Z 2016-09-20 2016-09-20 2016-09-20T14:52:15Z 2016-09-21T04:53:38Z 60842.0

14747946 rows × 21 columns

In [5]:
pageinfo = pd.read_csv(page_info_path)
politifact_with_fake_domain = pd.read_csv(politifact_fake_domain_path)
page_category = pageinfo[['page_id','category','type']]
politifact_with_fake_domain = politifact_with_fake_domain.join(page_category.set_index('page_id'), on='page_id')
politifact_with_fake_domain
Out[5]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count domain category type
0 440106476051475 Freedom Daily 440106476051475_1308905149171599 link Donald Trump Thinks Some Kids NEED a GOOD Old ... Donald Trump Thinks Some Kids NEED a GOOD Ol' ... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/donald-trump-thinks-ki... A good 'Ol Whoopin! ... 2016-11-22T10:28:48Z 2016-12-10T19:02:11Z 2016-11-22 2016-12-10 2016-11-22T16:28:48Z 2016-12-11T01:02:11Z 203082.0 FreedomDaily.com Media/News/Publishing media
1 610045389164725 Liberal Daily 610045389164725_770596729776256 link "Grow A Nut", Whoopi Doesn't Hold Back, Just T... Whoopi is pissed off, just let loose on the sp... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/02/07/grow-nut-who... NaN ... 2017-02-07T14:00:03Z 2017-04-03T18:43:49Z 2017-02-07 2017-04-03 2017-02-07T20:00:03Z 2017-04-03T23:43:49Z 165919.0 LiberalPlug.com Media/News/Publishing media
2 440106476051475 Freedom Daily 440106476051475_1138216752907107 link Home Invasion Thug Stabs 75-Year-Old Man, 80-Y... Home Invasion Thug Stabs 75-Year-Old Man, 80-Y... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/home-invasion-thug-sta... An intruder broke into a home in Monroe, Washi... ... 2016-05-01T16:30:00Z 2016-05-03T13:40:50Z 2016-05-01 2016-05-03 2016-05-01T21:30:00Z 2016-05-03T18:40:50Z 273614.0 FreedomDaily.com Media/News/Publishing media
3 440106476051475 Freedom Daily 440106476051475_1376156649113115 link Donald Trump Thinks Some Kids NEED a GOOD Old ... Donald Trump Thinks Some Kids NEED a GOOD Old ... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/donald-trump-thinks-ki... A good 'Ol Whoopin! ... 2017-01-15T11:03:18Z 2017-01-22T11:47:35Z 2017-01-15 2017-01-22 2017-01-15T17:03:18Z 2017-01-22T17:47:35Z 200739.0 FreedomDaily.com Media/News/Publishing media
4 610045389164725 Liberal Daily 610045389164725_758948130941116 link Jimmy Carter Flew To DC For Inauguration...But... This is how a man of HONOR and DIGNITY behaves... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/01/21/jimmy-carter... NaN ... 2017-01-21T17:30:00Z 2017-01-26T20:19:55Z 2017-01-21 2017-01-26 2017-01-21T23:30:00Z 2017-01-27T02:19:55Z 171811.0 LiberalPlug.com Media/News/Publishing media
5 440106476051475 Freedom Daily 440106476051475_1279170668811714 link Media RAGING After City's Biggest Police Union... Media RAGING After City's Biggest Police Union... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/media-raging-citys-big... HAha! Liberal media is freaking out because Sh... ... 2016-10-24T10:24:08Z 2016-10-26T03:01:07Z 2016-10-24 2016-10-26 2016-10-24T15:24:08Z 2016-10-26T08:01:07Z 437482.0 FreedomDaily.com Media/News/Publishing media
6 610045389164725 Liberal Daily 610045389164725_755235044645758 link Liz Warren Just Struck At Trump With A Bill Th... Hero Senator Liz Warren just filed a bill that... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/01/15/liz-warren-j... NaN ... 2017-01-15T13:21:00Z 2017-02-18T21:07:05Z 2017-01-15 2017-02-18 2017-01-15T19:21:00Z 2017-02-19T03:07:05Z 171811.0 LiberalPlug.com Media/News/Publishing media
7 610045389164725 Liberal Daily 610045389164725_774673936035202 link Congressman Who Called Trump "Racist" Refuses ... A Dem congressman caught flak for calling Trum... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/02/14/congressman-... NaN ... 2017-02-14T14:00:00Z 2017-02-21T04:58:28Z 2017-02-14 2017-02-21 2017-02-14T20:00:00Z 2017-02-21T10:58:28Z 165919.0 LiberalPlug.com Media/News/Publishing media
8 440106476051475 Freedom Daily 440106476051475_1224681280927320 link Army Ranger DESTROYS 49ers QB Colin Kaepernick... BOOM! Army Ranger DESTROYS 49ers QB Colin Kaep... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/army-ranger-destroys-4... This is Why I love the United States Military! ... 2016-08-27T20:00:00Z 2016-08-29T13:25:39Z 2016-08-27 2016-08-29 2016-08-28T01:00:00Z 2016-08-29T18:25:39Z 726536.0 FreedomDaily.com Media/News/Publishing media
9 610045389164725 Liberal Daily 610045389164725_763381843831078 link Bernie Sanders Brilliantly DESTROYS Trump Afte... Sanders just declared WAR on Trump!\nCan we ge... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/01/27/bernie-sande... NaN ... 2017-01-26T23:30:00Z 2017-02-18T21:27:24Z 2017-01-26 2017-02-18 2017-01-27T05:30:00Z 2017-02-19T03:27:24Z 171811.0 LiberalPlug.com Media/News/Publishing media
10 610045389164725 Liberal Daily 610045389164725_767101610125768 link Al Franken Let Loose On Nutjob Ted Cruz For Tr... Al Franken just wiped the Senate floor with Te... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/02/02/al-franken-l... NaN ... 2017-02-02T16:00:00Z 2017-02-08T01:44:30Z 2017-02-02 2017-02-08 2017-02-02T22:00:00Z 2017-02-08T07:44:30Z 165919.0 LiberalPlug.com Media/News/Publishing media
11 440106476051475 Freedom Daily 440106476051475_1314611048601009 link QUESTION – Do You Support Patriotic Bikers DEF... QUESTION – Do You Support Patriotic Bikers DEF... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/bikers-trumps-inaugura... Liberals beware! Come starting trouble, face t... ... 2016-11-27T16:18:36Z 2017-01-18T10:26:47Z 2016-11-27 2017-01-18 2016-11-27T22:18:36Z 2017-01-18T16:26:47Z 203082.0 FreedomDaily.com Media/News/Publishing media
12 591402597574018 Tell Me Now 591402597574018_1065863346794605 link This White House Petition to CHARGE Hillary Re... EAT. THIS. HILDEBEEST. \nLet's push this OVER ... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/white-house-peti... Hillary may have gotten her way with the FBI, ... ... 2016-07-07T20:00:00Z 2016-07-09T11:11:32Z 2016-07-07 2016-07-09 2016-07-08T01:00:00Z 2016-07-09T16:11:32Z 349481.0 ClashDaily.com News/Media Website media
13 440106476051475 Freedom Daily 440106476051475_1251684991560282 link Florida Sheriff’s Office Will Not Escort Miami... Florida Sheriff’s Office Just told The NFL's M... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/florida-sheriffs-dolph... Police unions from the Miami area are refusing... ... 2016-09-25T16:30:45Z 2016-09-27T10:27:47Z 2016-09-25 2016-09-27 2016-09-25T21:30:45Z 2016-09-27T15:27:47Z 910882.0 FreedomDaily.com Media/News/Publishing media
14 440106476051475 Freedom Daily 440106476051475_1225200414208740 link US Marine With No Legs Destroys Colin Kaeperni... US Marine With No Legs Destroys Colin Kaeperni... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/us-marine-with-no-legs... Stinson is a true hero who sacrificed everythi... ... 2016-08-28T11:30:00Z 2016-08-30T09:08:20Z 2016-08-28 2016-08-30 2016-08-28T16:30:00Z 2016-08-30T14:08:20Z 726536.0 FreedomDaily.com Media/News/Publishing media
15 610045389164725 Liberal Daily 610045389164725_748604821975447 link Bernie Sanders ROASTS Trump On Twitter, Trump ... Well, that escalated quickly. \nBernie is not ... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/01/05/bernie-sande... NaN ... 2017-01-04T21:00:00Z 2017-01-12T08:46:16Z 2017-01-04 2017-01-12 2017-01-05T03:00:00Z 2017-01-12T14:46:16Z 171811.0 LiberalPlug.com Media/News/Publishing media
16 440106476051475 Freedom Daily 440106476051475_1297937750268339 link YES! Rosie O’Donnell Confirms She’s Moving Fro... YES! Rosie O’Donnell Confirms She’s Moving Fro... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/yes-rosie-odonnell-con... Pack your sh*t and go! Rosie O is gonna hit th... ... 2016-11-12T06:30:00Z 2016-11-12T06:30:00Z 2016-11-12 2016-11-12 2016-11-12T12:30:00Z 2016-11-12T12:30:00Z 203082.0 FreedomDaily.com Media/News/Publishing media
17 440106476051475 Freedom Daily 440106476051475_1140607812668001 link Sheriff Arpaio Slaps Obama, Court Reverses Ban... AWESOME NEWS! Sheriff Arpaio B**** Slaps Obam... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/sheriff-arpaio-slaps-o... A federal appeals court has lifted a judge’s r... ... 2016-05-05T10:00:01Z 2016-05-07T08:46:06Z 2016-05-05 2016-05-07 2016-05-05T15:00:01Z 2016-05-07T13:46:06Z 306497.0 FreedomDaily.com Media/News/Publishing media
18 610045389164725 Liberal Daily 610045389164725_771278083041454 link Experts Suggest That We Start The Impeachment ... I don’t think Richard Nixon even comes close t... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/02/08/experts-sugg... NaN ... 2017-02-09T02:00:05Z 2017-02-14T20:07:42Z 2017-02-09 2017-02-14 2017-02-09T08:00:05Z 2017-02-15T02:07:42Z 165919.0 LiberalPlug.com Media/News/Publishing media
19 440106476051475 Freedom Daily 440106476051475_1230898893638892 link Muslims Threaten… “If Donald Trump Will Be The... Muslims Threaten… “If Donald Trump Will Be The... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/muslims-threaten-donal... Here's a reason to VOTE Trump! You in? ... 2016-09-02T23:30:00Z 2016-09-04T20:59:07Z 2016-09-02 2016-09-04 2016-09-03T04:30:00Z 2016-09-05T01:59:07Z 546081.0 FreedomDaily.com Media/News/Publishing media
20 440106476051475 Freedom Daily 440106476051475_1307121579349956 link Home Invasion Thug Stabs 75-Year-Old Man, 80-Y... HOME INVASION: Thug Stabs 75-Year-Old Man, 80-... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/home-invasion-thug-sta... An intruder broke into a home in Monroe, Washi... ... 2016-11-20T16:00:17Z 2016-11-25T21:41:57Z 2016-11-20 2016-11-25 2016-11-20T22:00:17Z 2016-11-26T03:41:57Z 203082.0 FreedomDaily.com Media/News/Publishing media
21 440106476051475 Freedom Daily 440106476051475_1239048326157282 link WOW! 156,000 Fans Give NFL The FINGER & Sing '... WOW! 156,000 Fans Give NFL The FINGER & Sing ‘... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/156000-fans-give-nfl-f... College football made a record last night with... ... 2016-09-11T09:30:46Z 2016-09-12T23:36:55Z 2016-09-11 2016-09-12 2016-09-11T14:30:46Z 2016-09-13T04:36:55Z 638065.0 FreedomDaily.com Media/News/Publishing media
22 211482380627 Disclose.tv 211482380627_10153207990060628 link Woman Sets Her Husband On FIRE For Sexually AB... Woman Sets Her Husband On FIRE For Sexually AB... www.disclose.tv https://scontent.xx.fbcdn.net/t45.1600-4/c54.0... http://www.disclose.tv/news/Woman_Sets_Her_Hus... Vincent Phillips, age given as 52, was doused ... ... 2015-02-28T14:00:56Z 2015-03-15T22:40:19Z 2015-02-28 2015-03-15 2015-02-28T20:00:56Z 2015-03-16T03:40:19Z 384061.0 Disclose.tv Media/News/Publishing media
23 440106476051475 Freedom Daily 440106476051475_1295590357169745 link WATCH: Stop Blaming 'WHITE PEOPLE' For Trumps ... WATCH: Stop Blaming 'WHITE PEOPLE' For Trumps ... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/watch-stop-blaming-whi... She STICKS IT to the liberal whiners. ... 2016-11-09T19:02:37Z 2016-11-12T12:49:54Z 2016-11-09 2016-11-12 2016-11-10T01:02:37Z 2016-11-12T18:49:54Z 203082.0 FreedomDaily.com Media/News/Publishing media
24 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1137734596343317 link LMAO: Michelle’s Designer Vows To NEVER Dress ... ICYMI - our post is currently melting the inte... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/KFsx306ru52 Michelle has been touted as a ‘style icon’. We... ... 2016-11-23T04:20:12Z 2016-12-05T20:42:10Z 2016-11-23 2016-12-05 2016-11-23T10:20:12Z 2016-12-06T02:42:10Z 160456.0 ClashDaily.com News/Media Website media
25 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1144782218971888 link LMAO: Michelle’s Designer Vows To NEVER Dress ... WHEW! Thank God! America ... we dodged a BULLE... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/JsRK306zp9x Michelle has been touted as a ‘style icon’. We... ... 2016-11-28T00:20:11Z 2016-11-29T04:35:10Z 2016-11-28 2016-11-29 2016-11-28T06:20:11Z 2016-11-29T10:35:10Z 678047.0 ClashDaily.com News/Media Website media
26 440106476051475 Freedom Daily 440106476051475_1308261282569319 link Muslim Infiltrators Angry that Small Town Colo... STAND YOUR GROUND! Muslim are IRATE that Small... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/muslim-infiltrators-an... “Somalis’ assimilation in Colorado farm town s... ... 2016-11-21T19:00:00Z 2016-11-21T19:00:00Z 2016-11-21 2016-11-21 2016-11-22T01:00:00Z 2016-11-22T01:00:00Z 203082.0 FreedomDaily.com Media/News/Publishing media
27 440106476051475 Freedom Daily 440106476051475_1132490236813092 link McDonald's, Pizza Hut And KFC Refuse Muslim De... MUSLIMS FLIP OUT! McDonald’s, Pizza Hut And KF... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/mcdonalds-pizza-hut-an... Arshad reportedly contacted the big three to r... ... 2016-04-23T10:15:00Z 2016-04-25T08:23:42Z 2016-04-23 2016-04-25 2016-04-23T15:15:00Z 2016-04-25T13:23:42Z 326201.0 FreedomDaily.com Media/News/Publishing media
28 610045389164725 Liberal Daily 610045389164725_763795857123010 link Malia Obama Takes AMAZING Stand Against Trump,... She the PERFECT role model for young women!\nW... liberalplug.com https://external.xx.fbcdn.net/safe_image.php?d... http://liberalplug.com/2017/01/27/malia-obama-... NaN ... 2017-01-28T20:30:00Z 2017-02-01T16:29:50Z 2017-01-28 2017-02-01 2017-01-29T02:30:00Z 2017-02-01T22:29:50Z 171811.0 LiberalPlug.com Media/News/Publishing media
29 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1139785816138195 link LMAO: Michelle’s Designer Vows To NEVER Dress ... WHEW! Thank God! America ... we dodged a BULLE... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/11/lmao-michelles-d... Michelle has been touted as a ‘style icon’. We... ... 2016-11-24T18:45:01Z 2016-11-26T06:07:45Z 2016-11-24 2016-11-26 2016-11-25T00:45:01Z 2016-11-26T12:07:45Z 800737.0 ClashDaily.com News/Media Website media
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
132295 312531385450925 The Last Great Stand 312531385450925_934259086611482 link 9 Reasons the Terrorist Attacks in Paris Could... 9 Reasons the Terrorist Attacks in Paris Could... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1QnzFrx My heart goes out to anyone who lost a family ... ... 2015-11-16T09:33:39Z 2015-11-16T09:33:39Z 2015-11-16 2015-11-16 2015-11-16T15:33:39Z 2015-11-16T15:33:39Z 8055.0 BeforeItsNews.com Politician media
132296 312531385450925 The Last Great Stand 312531385450925_1022081877829202 link Jim Willie and Will The U.S. Collapse Due To I... Jim Willie and Will The U.S. Collapse Due To I... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1pDIRwF In this interview below between Rick Wile of T... ... 2016-04-27T04:58:31Z 2016-04-27T04:58:31Z 2016-04-27 2016-04-27 2016-04-27T09:58:31Z 2016-04-27T09:58:31Z 22852.0 BeforeItsNews.com Politician media
132297 312531385450925 The Last Great Stand 312531385450925_924625567574834 link How Aliens Helped to Build Earth’s Ancient Pyr... How Aliens Helped to Build Earth’s Ancient Pyr... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1LndPjk EVERYTHING WE HAVE BEEN TAUGHT ABOUT HUMAN ORI... ... 2015-10-24T06:40:17Z 2015-10-24T06:40:17Z 2015-10-24 2015-10-24 2015-10-24T11:40:17Z 2015-10-24T11:40:17Z 3727.0 BeforeItsNews.com Politician media
132298 312531385450925 The Last Great Stand 312531385450925_875427919161266 link Obama Scheming with Financial Institutions to ... NaN beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://thelastgreatstand.tumblr.com/post/12325... What do you get when you mix the latest versio... ... 2015-07-05T00:14:45Z 2015-07-05T00:14:45Z 2015-07-05 2015-07-05 2015-07-05T05:14:45Z 2015-07-05T05:14:45Z 6106.0 BeforeItsNews.com Politician media
132299 312531385450925 The Last Great Stand 312531385450925_942872432416814 link Peter Schiff and "11 Alarms Being Ignored As T... Peter Schiff and “11 Alarms Being Ignored As T... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1Qh2fcG In the following video, Peter Schiff pokes fun... ... 2015-12-03T12:49:23Z 2015-12-03T12:49:23Z 2015-12-03 2015-12-03 2015-12-03T18:49:23Z 2015-12-03T18:49:23Z 13809.0 BeforeItsNews.com Politician media
132300 312531385450925 The Last Great Stand 312531385450925_911718795532178 link Top 10 Extremely Bizarre Phobias People Have –... SOME OF THESE WILL MAKE YOU LAUGH (#2); SOME M... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/alternative/2015/09/t... In a world where just about every actual news ... ... 2015-09-23T13:02:08Z 2015-09-23T13:02:08Z 2015-09-23 2015-09-23 2015-09-23T18:02:08Z 2015-09-23T18:02:08Z 3108.0 BeforeItsNews.com Politician media
132301 312531385450925 The Last Great Stand 312531385450925_922013361169388 link Thirty-one Rare and Interesting Pictures Of th... 31 Rare and Interesting Pictures Of The World ... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/alternative/2015/07/3... CHECK OUT OTHER STORIES BY THE UN-SILENT MAJOR... ... 2015-10-17T16:00:14Z 2015-10-17T16:00:14Z 2015-10-17 2015-10-17 2015-10-17T21:00:14Z 2015-10-17T21:00:14Z 9719.0 BeforeItsNews.com Politician media
132302 312531385450925 The Last Great Stand 312531385450925_911855005518557 link 10 Extremely Bizarre Phobias People Have – #2 ... Top 10 Extremely Bizarre Phobias People Have –... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/alternative/2015/09/t... In a world where just about every actual news ... ... 2015-09-23T21:00:07Z 2015-09-23T21:00:07Z 2015-09-23 2015-09-23 2015-09-24T02:00:07Z 2015-09-24T02:00:07Z 3108.0 BeforeItsNews.com Politician media
132303 312531385450925 The Last Great Stand 312531385450925_890496244321100 link Why Are The Illuminati Planning To Crash the G... NaN beforeitsnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://thelastgreatstand.tumblr.com/post/12616... Why Are The Illuminati Planning To Crash the G... ... 2015-08-08T04:33:01Z 2015-08-08T04:33:01Z 2015-08-08 2015-08-08 2015-08-08T09:33:01Z 2015-08-08T09:33:01Z 4367.0 BeforeItsNews.com Politician media
132304 146612062031906 Spokane Conservative Examiner 146612062031906_1431105400249226 link WOW! State Department Spokesperson Thinks The ... “This administration fiddles while Rome burns…... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/state-department-spokesperson... Welcome to the State Department. This administ... ... 2016-08-05T10:30:00Z 2016-08-05T10:30:00Z 2016-08-05 2016-08-05 2016-08-05T15:30:00Z 2016-08-05T15:30:00Z 8225.0 BB4SP.com News/Media Website media
132305 146612062031906 Spokane Conservative Examiner 146612062031906_1362424760450624 link 2013 West Texas Fertilizer Blast That Killed 1... “The ATF government agents are super fast at t... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/2013-west-texas-fertilizer-bl... Officials launched a hunt Wednesday for possib... ... 2016-05-12T10:30:00Z 2016-05-12T10:30:00Z 2016-05-12 2016-05-12 2016-05-12T15:30:00Z 2016-05-12T15:30:00Z 9442.0 BB4SP.com News/Media Website media
132306 305986132775543 Revive America 305986132775543_989784887728994 link White House Forces LGBT Applicants on Ministri... The White House is poised to order faith-based... libertyalliance.com https://fbexternal-a.akamaihd.net/safe_image.p... http://libertyalliance.com/white-house-forces-... Faith and Freedom with Liberty Counsel’s Mat S... ... 2015-06-16T12:30:04Z 2015-06-16T22:46:46Z 2015-06-16 2015-06-16 2015-06-16T17:30:04Z 2015-06-17T03:46:46Z 19307.0 LibertyAlliance.com Media/News/Publishing media
132307 312531385450925 The Last Great Stand 312531385450925_912281835475874 link Dying US Political Prisoner at 87 (Peter Schif... Blind and Dying US Political Prisoner at 87 (P... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://buff.ly/1Mti64W Do you want to know what a lawless tyrannical ... ... 2015-09-25T02:59:38Z 2015-09-25T02:59:38Z 2015-09-25 2015-09-25 2015-09-25T07:59:38Z 2015-09-25T07:59:38Z 2953.0 BeforeItsNews.com Politician media
132308 146612062031906 Spokane Conservative Examiner 146612062031906_1424280810931685 link Inmates Take Over Portion Of A Jail In Chicago... “Officials said they are working to resolve th... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/cook-county-jail-inmates-chic... Officials said they are working to resolve the... ... 2016-07-28T21:30:00Z 2016-07-28T21:30:00Z 2016-07-28 2016-07-28 2016-07-29T02:30:00Z 2016-07-29T02:30:00Z 12819.0 BB4SP.com News/Media Website media
132309 312531385450925 The Last Great Stand 312531385450925_937766779594046 link 5-Year-Old Genius Has Scientists Believing Tha... 5-Year-Old Genius Has Scientists Believing Tha... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1LrVpL2 No doubt this kid is most impressive. I’m push... ... 2015-11-22T08:50:28Z 2015-11-22T08:50:28Z 2015-11-22 2015-11-22 2015-11-22T14:50:28Z 2015-11-22T14:50:28Z 14210.0 BeforeItsNews.com Politician media
132310 312531385450925 The Last Great Stand 312531385450925_957931900910867 link Police To Begin Trolling Even People's "Hidden... Police To Begin Trolling Even People’s “Hidden... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1R2zp1F In the first video below, RT discusses a new b... ... 2016-01-02T08:49:23Z 2016-01-02T14:25:19Z 2016-01-02 2016-01-02 2016-01-02T14:49:23Z 2016-01-02T20:25:19Z 6158.0 BeforeItsNews.com Politician media
132311 312531385450925 The Last Great Stand 312531385450925_927025187334872 link Cleric Says: "Muslims Have the Right to Kill A... “Moderate” Cleric Says: “Muslims Have the Righ... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/20eHFON Look at that picture above. Those “peaceful Mu... ... 2015-10-30T04:10:22Z 2015-10-30T04:10:22Z 2015-10-30 2015-10-30 2015-10-30T09:10:22Z 2015-10-30T09:10:22Z 3239.0 BeforeItsNews.com Politician media
132312 149817218374125 Girls Just Wanna Have Guns 149817218374125_963106277045211 link 10 REASONS: Why I Could Never Be The Pope ⋆ Do... I appreciate Pope Francis' stand for trad marr... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/SIWEZ I'm glad, for many reasons, that Boehner resig... ... 2015-09-27T17:40:21Z 2015-09-27T17:51:34Z 2015-09-27 2015-09-27 2015-09-27T22:40:21Z 2015-09-27T22:51:34Z 11405.0 ClashDaily.com Cause group
132313 312531385450925 The Last Great Stand 312531385450925_931396080231116 link 10 Ancient Settlements That Were Abandoned for... 10 Ancient Settlements That Were Abandoned for... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1PvfhTx (Image: Carlos Adampol, cc-sa-4.0) The ten anc... ... 2015-11-09T09:20:58Z 2015-11-09T09:20:58Z 2015-11-09 2015-11-09 2015-11-09T15:20:58Z 2015-11-09T15:20:58Z 2964.0 BeforeItsNews.com Politician media
132314 312531385450925 The Last Great Stand 312531385450925_945083818862342 link China Knocking on the Door of Global Reserve-C... China Knocking on the Door of Global Reserve-C... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/politics/2015/08/chin... FOR MORE NEWS BY VOICE OF REASON CLICK HERE! B... ... 2015-12-08T06:00:16Z 2015-12-08T06:00:16Z 2015-12-08 2015-12-08 2015-12-08T12:00:16Z 2015-12-08T12:00:16Z 8946.0 BeforeItsNews.com Politician media
132315 425390150874429 Sean Brown 425390150874429_847069882039785 link Teen’s Final Day Of School Becomes ‘Extreme’ N... On her last day of school before graduation, a... madworldnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://madworldnews.com/teens-final-day-school... On her last day of school before graduation, a... ... 2015-05-20T17:36:54Z 2015-05-20T17:36:54Z 2015-05-20 2015-05-20 2015-05-20T22:36:54Z 2015-05-20T22:36:54Z 1515.0 MadWorldNews.com Journalist figure
132316 312531385450925 The Last Great Stand 312531385450925_933402920030432 link UFO Activists Excited About Hillary Presidency... UFO Activists Excited About Hillary Presidency... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1NScsMv Illustration by Ivylise Simones; Clinton: Bria... ... 2015-11-14T08:36:11Z 2015-11-14T08:36:11Z 2015-11-14 2015-11-14 2015-11-14T14:36:11Z 2015-11-14T14:36:11Z 5854.0 BeforeItsNews.com Politician media
132317 751413538254047 America is RIGHT 751413538254047_1193759067352823 link Where Are Barack And Michelle, Black Lives Mat... Where Are Barack And Michelle, Black Lives Mat... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/barack-michelle-black-... I'm sure you've all realized by now that to li... ... 2016-05-31T08:38:28Z 2016-05-31T08:38:28Z 2016-05-31 2016-05-31 2016-05-31T13:38:28Z 2016-05-31T13:38:28Z 12306.0 FreedomDaily.com Media/News/Publishing group
132318 312531385450925 The Last Great Stand 312531385450925_922652831105441 link The TPP Has a Secret Clause to Limit Free Spee... The TPP Has a Secret Clause to Limit Free Spee... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/politics/2015/10/the-... As we head into what is “scheduled” to be Obam... ... 2015-10-19T09:00:42Z 2015-10-19T23:28:04Z 2015-10-19 2015-10-19 2015-10-19T14:00:42Z 2015-10-20T04:28:04Z 9719.0 BeforeItsNews.com Politician media
132319 146612062031906 Spokane Conservative Examiner 146612062031906_1474129272613505 link Device Explodes Along Military 5K Route, 2nd D... Device Explodes Along Military 5K Route, 2nd D... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/device-explodes-along-militar... Luckily no one was in the area when the device... ... 2016-09-18T02:00:15Z 2016-09-18T02:00:15Z 2016-09-18 2016-09-18 2016-09-18T07:00:15Z 2016-09-18T07:00:15Z 7819.0 BB4SP.com News/Media Website media
132320 312531385450925 The Last Great Stand 312531385450925_1004374316266625 link Dr. Jim Willie - Secret Meeting at the G20 to ... Dr. Jim Willie – Secret Meeting at the G20 to ... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1UUTyah In the following video, USA Watchdog talks to ... ... 2016-03-28T08:36:26Z 2016-03-28T08:36:26Z 2016-03-28 2016-03-28 2016-03-28T13:36:26Z 2016-03-28T13:36:26Z 40831.0 BeforeItsNews.com Politician media
132321 425390150874429 Sean Brown 425390150874429_855493394530767 link Cameras Catch ‘CREEPY’ Thing Man Did In Walmar... Police were recently on the lookout for a man ... madworldnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://madworldnews.com/cameras-creepy-man-wal... Police were recently on the lookout for a man ... ... 2015-06-06T12:37:21Z 2015-06-06T12:59:25Z 2015-06-06 2015-06-06 2015-06-06T17:37:21Z 2015-06-06T17:59:25Z 1906.0 MadWorldNews.com Journalist figure
132322 146612062031906 Spokane Conservative Examiner 146612062031906_1487477401278692 link Hillary Mocks Sanders Supporters In Leaked Fun... “She mocks the millennials while her supporter... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/hillary-mocks-sanders-support... She mocks the millennials while her supporters... ... 2016-10-01T12:30:01Z 2016-10-01T12:30:01Z 2016-10-01 2016-10-01 2016-10-01T17:30:01Z 2016-10-01T17:30:01Z 4655.0 BB4SP.com News/Media Website media
132323 312531385450925 The Last Great Stand 312531385450925_927231550647569 link 6 Ways To Show The World Is In Cognitive Disso... 6 Ways To Show The World Is In Cognitive Disso... beforeitsnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://beforeitsnews.com/politics/2015/10/6-wa... Wait up, hold on, hold the phone here! Why is ... ... 2015-10-30T16:00:45Z 2015-10-30T16:00:45Z 2015-10-30 2015-10-30 2015-10-30T21:00:45Z 2015-10-30T21:00:45Z 2957.0 BeforeItsNews.com Politician media
132324 312531385450925 The Last Great Stand 312531385450925_1005211816182875 link Jim Willie and How the Loss of the US Dollar a... Jim Willie and How the Loss of the US Dollar a... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1MHUpEO In the following video, Dr. Jim Willie is a gu... ... 2016-03-29T10:40:52Z 2016-03-29T10:40:52Z 2016-03-29 2016-03-29 2016-03-29T15:40:52Z 2016-03-29T15:40:52Z 40831.0 BeforeItsNews.com Politician media

132325 rows × 24 columns

each page average likes shares comments

In [6]:
all_page_average = all_post.groupby("page_name").mean()
all_page_average['count']= all_post.groupby("page_name").size()
In [7]:
all_page_average = all_page_average[['post_likes','post_comments','post_shares','count']]
all_page_average.reset_index(inplace=True)
all_page_average.to_excel(writer,'All_Page_Average')
In [8]:
fake_page_list = list(politifact_with_fake_domain.page_name.unique())
In [9]:
fake_page_detail = all_post[all_post.page_name.isin(fake_page_list)]
true_page_detail = all_post[~all_post.page_name.isin(fake_page_list)]
In [10]:
column = ['avg_like','avg_share','avg_comment']
fake_true_comparison = pd.DataFrame(columns=column)
fake_page_info = [{"avg_like":fake_page_detail.post_likes.mean(),
                  "avg_share":fake_page_detail.post_shares.mean(),
                  "avg_comment":fake_page_detail.post_comments.mean()}]
true_page_info = [{"avg_like":true_page_detail.post_likes.mean(),
                 "avg_share":true_page_detail.post_shares.mean(),
                 "avg_comment":true_page_detail.post_comments.mean()}]
fake_true_comparison = fake_true_comparison.append(fake_page_info)
fake_true_comparison = fake_true_comparison.append(true_page_info)
fake_true_comparison.index = ['Fake_Page','True_Page']
fake_true_comparison.to_excel(writer,'fake_true_page_comparison')
In [11]:
politician = Path('/home3/usfb/analysis/analysis-fake-news/temp/post-match-domain/politician.csv')
politicians = pd.read_csv(politician)
politician_list = list(politicians.page_name.unique())
politicians
Out[11]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_likes post_comments post_shares post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count
0 69983322463 Ted Cruz 69983322463_10153184451317464 link Exclusive — Ted Cruz: My First Act As Presiden... If I am elected president, the very first thin... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... Sen. Ted Cruz (R-TX) tells Breitbart News that... ... 100444 7726 14060.0 2015-04-01T08:50:48Z 2015-04-01T08:50:48Z 2015-04-01 2015-04-01 2015-04-01T13:50:48Z 2015-04-01T13:50:48Z 48346
1 69983322463 Ted Cruz 69983322463_10153694961642464 link Appeals Court Stops Obama’s Executive Amnesty A victory for the rule of law as the Fifth Cir... www.breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2015/11/09/appe... The Fifth Circuit Court of Appeals issued a ru... ... 63289 2770 12658.0 2015-11-09T21:10:00Z 2015-11-11T20:23:42Z 2015-11-09 2015-11-11 2015-11-10T03:10:00Z 2015-11-12T02:23:42Z 231294
2 69983322463 Ted Cruz 69983322463_10153409437797464 link Cruz: 'Sad' US Will Have Embassy in Havana Bef... How sad is it that under the Obama administrat... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/video/2015/07/01/cruz... Ted Cruz asked "How sad is it that...the Unite... ... 58409 4403 15383.0 2015-07-02T08:27:52Z 2015-07-03T14:31:29Z 2015-07-02 2015-07-03 2015-07-02T13:27:52Z 2015-07-03T19:31:29Z 223716
3 69983322463 Ted Cruz 69983322463_10153738581777464 link Ted Cruz: Now, More Than Ever, Americans Must ... The gun control push illustrates the misguided... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/2016-presidential-rac... Ted Cruz talks about the Democrats' attempts t... ... 55599 2474 17300.0 2015-12-04T08:04:13Z 2015-12-06T03:26:52Z 2015-12-04 2015-12-06 2015-12-04T14:04:13Z 2015-12-06T09:26:52Z 340353
4 50375006903 Louie Gohmert 50375006903_10153010227126904 link Today is Chris Kyle Day in Texas Today is Chris Kyle day in Texas! breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2015/02/02/toda... February 2nd is Chris Kyle Day, declared Texas... ... 51979 552 6237.0 2015-02-02T09:09:53Z 2015-02-14T10:39:11Z 2015-02-02 2015-02-14 2015-02-02T15:09:53Z 2015-02-14T16:39:11Z 5278
5 181888625087 Greg Abbott 181888625087_10155663633110088 link It’s Official: Texas Legislature Passes Open C... Open Carry passed in both the Texas House & Se... www.breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/texas/2015/05/29/its-... The Texas House and Senate have adopted the Co... ... 43244 3358 25075.0 2015-05-29T21:55:56Z 2015-05-31T20:55:35Z 2015-05-29 2015-05-31 2015-05-30T02:55:56Z 2015-06-01T01:55:35Z 101314
6 69983322463 Ted Cruz 69983322463_10153569278032464 link Over $500,000 Raised for Executed Texas Deputy... What a tremendous outpouring of support for De... breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/texas/2015/09/07/over... More than $500,000 has been raised for the fam... ... 42553 756 4755.0 2015-09-07T19:31:27Z 2015-09-09T14:30:15Z 2015-09-07 2015-09-09 2015-09-08T00:31:27Z 2015-09-09T19:30:15Z 359365
7 69983322463 Ted Cruz 69983322463_10153721282762464 link Iowa Surge: Ted Cruz, Donald Trump Statistical... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... Iowa Surge: Ted Cruz, Donald Trump Statistical... ... 34118 1504 4545.0 2015-11-24T10:07:38Z 2015-11-26T07:56:28Z 2015-11-24 2015-11-26 2015-11-24T16:07:38Z 2015-11-26T13:56:28Z 378174
8 181888625087 Greg Abbott 181888625087_10156446677355088 link Texas Governor Calls for Article V Constitutio... Today I announced the Texas Plan, calling for ... Breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2016/01/08/texa... Governor Greg Abbott calls on Texas to join ot... ... 30152 2052 8843.0 2016-01-08T19:17:53Z 2016-01-10T17:55:29Z 2016-01-08 2016-01-10 2016-01-09T01:17:53Z 2016-01-10T23:55:29Z 246936
9 181888625087 Greg Abbott 181888625087_10156217770990088 link Sanctuary Cities Policies Will "No Longer Be T... Today I called for an end to sanctuary city po... Breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2015/10/26/sanc... The Governor said sanctuary city policies like... ... 26946 2282 9294.0 2015-10-26T11:52:30Z 2015-10-28T09:19:14Z 2015-10-26 2015-10-28 2015-10-26T16:52:30Z 2015-10-28T14:19:14Z 119664
10 69983322463 Ted Cruz 69983322463_10153669871447464 link Sanctuary Cities Policies Will "No Longer Be T... #StopSanctuaryCities: https://www.tedcruz.org/... Breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2015/10/26/sanc... The Governor said sanctuary city policies like... ... 26495 740 3629.0 2015-10-26T15:04:16Z 2015-10-28T10:33:47Z 2015-10-26 2015-10-28 2015-10-26T20:04:16Z 2015-10-28T15:33:47Z 159688
11 181888625087 Greg Abbott 181888625087_10157796308385088 link Anti-Sanctuary City Bill Filed by Texas State ... I strongly support this and expect to sign it ... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2016/11/16/anti... NaN ... 25016 1048 4137.0 2016-11-17T18:15:00Z 2016-11-19T17:35:59Z 2016-11-17 2016-11-19 2016-11-18T00:15:00Z 2016-11-19T23:35:59Z 186640
12 69983322463 Ted Cruz 69983322463_10153472951167464 link Sens. Paul and Cruz Go After Hillary on Planne... Today is a time for action. Today the U.S. Dep... breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/big-government/2015/0... The Capitol Hill rally was one 65 organized by... ... 24800 956 3538.0 2015-07-29T07:50:51Z 2015-07-31T07:33:14Z 2015-07-29 2015-07-31 2015-07-29T12:50:51Z 2015-07-31T12:33:14Z 228587
13 181888625087 Greg Abbott 181888625087_10157634238195088 link Two Suspected ISIS Recruits Traveling to Mexic... Proud of Texas DPS working with FBI to arrest ... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2016/1... Two Wisconsin men have been arrested in San An... ... 22552 1011 6521.0 2016-10-17T12:27:45Z 2016-10-19T09:29:43Z 2016-10-17 2016-10-19 2016-10-17T17:27:45Z 2016-10-19T14:29:43Z 112851
14 69983322463 Ted Cruz 69983322463_10153543492007464 link Ted Cruz Vows To Defund Planned Parenthood, Pr... I intend to lead the fight to #DefundPlannedPa... breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/big-government/2015/0... Cruz told pastors when it comes to the funding... ... 21891 762 2337.0 2015-08-27T17:08:38Z 2015-08-29T12:08:25Z 2015-08-27 2015-08-29 2015-08-27T22:08:38Z 2015-08-29T17:08:25Z 221891
15 173347701125 Governor Jan Brewer 173347701125_10153888797811126 link START PACKING: 23 Celebrities Who Promised to ... NaN conservativetribune.com https://external.xx.fbcdn.net/safe_image.php?d... http://po.st/4vkATP And good riddance! ... 20776 3853 4687.0 2016-11-09T14:00:00Z 2016-11-11T01:46:34Z 2016-11-09 2016-11-11 2016-11-09T20:00:00Z 2016-11-11T07:46:34Z 324848
16 69983322463 Ted Cruz 69983322463_10153658346077464 link Ted Cruz Urges States To Follow Texas’ Lead in... I encourage every state to follow Texas’ lead ... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... Ted Cruz praised his home state of Texas for e... ... 20353 387 2631.0 2015-10-19T19:05:34Z 2015-10-21T14:17:27Z 2015-10-19 2015-10-21 2015-10-20T00:05:34Z 2015-10-21T19:17:27Z 230791
17 181888625087 Greg Abbott 181888625087_10156283879010088 link EXCLUSIVE -- REPORT: 8 Syrians Caught at Texas... THIS is why Texas is vigilant about Syrian ref... www.breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... Two federal agents operating under the umbrell... ... 20157 1461 16065.0 2015-11-18T20:36:16Z 2015-11-20T16:41:12Z 2015-11-18 2015-11-20 2015-11-19T02:36:16Z 2015-11-20T22:41:12Z 304636
18 181888625087 Greg Abbott 181888625087_10156244208205088 link Texas Governor Strips State Grant Funding From... As Governor, I will NOT allow Sheriffs of “san... Breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/texas/2015/11/04/texa... Texas Governor Greg Abbott announced a new pla... ... 19778 1283 3400.0 2015-11-04T13:59:10Z 2015-11-06T09:45:28Z 2015-11-04 2015-11-06 2015-11-04T19:59:10Z 2015-11-06T15:45:28Z 182990
19 69983322463 Ted Cruz 69983322463_10153342313917464 link Sen. Ted Cruz: Next President Should Immediate... The next president should immediately reimpose... breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/video/2015/05/31/sen-... Sen. Ted Cruz: Next President Should Immediate... ... 18102 755 2138.0 2015-06-01T11:49:11Z 2015-06-03T10:32:30Z 2015-06-01 2015-06-03 2015-06-01T16:49:11Z 2015-06-03T15:32:30Z 113036
20 69983322463 Ted Cruz 69983322463_10153463938587464 link Ted Cruz Hits McConnell Again On Rush’s Radio ... The #ExImBank is a classic example of cronyism... www.breitbart.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.breitbart.com/big-government/2015/0... Cruz has raised more hard money—$14.3 million—... ... 17686 896 2567.0 2015-07-25T12:55:41Z 2015-07-27T11:10:23Z 2015-07-25 2015-07-27 2015-07-25T17:55:41Z 2015-07-27T16:10:23Z 222587
21 173347701125 Governor Jan Brewer 173347701125_10153891930676126 link Trump Thrilled as Happy Firefighters Stage Mas... Everyday Americans are thrilled that Donald J.... conservativetribune.com https://external.xx.fbcdn.net/safe_image.php?d... http://po.st/bK3V08 These firefighters let their feelings about th... ... 17406 279 1935.0 2016-11-10T17:30:00Z 2016-11-12T06:48:05Z 2016-11-10 2016-11-12 2016-11-10T23:30:00Z 2016-11-12T12:48:05Z 352896
22 69983322463 Ted Cruz 69983322463_10153785092067464 link Exclusive–Bozell: It’s Time To Rally Around Te... NaN www.breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... It is time for conservatives to rally around T... ... 15859 597 2270.0 2015-12-26T15:58:45Z 2015-12-28T11:37:44Z 2015-12-26 2015-12-28 2015-12-26T21:58:45Z 2015-12-28T17:37:44Z 311803
23 54172246106 Rand Paul 54172246106_10153568055411107 link Poll: Rand Paul Won Undercard Debate...Because... "US News asked readers who they thought won th... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-journalism/2016/0... Poll: Rand Paul Won Undercard Debate...Because... ... 15836 461 2763.0 2016-01-15T08:51:34Z 2016-01-17T02:11:37Z 2016-01-15 2016-01-17 2016-01-15T14:51:34Z 2016-01-17T08:11:37Z 253925
24 181888625087 Greg Abbott 181888625087_10155315710495088 link Texas Leaders Seek Investigation into Obama Ad... I commend General Paxton for continuing to hol... Brietbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2015/03/05/texa... Texas Attorney General Ken Paxton filed a moti... ... 15469 909 2680.0 2015-03-05T20:02:34Z 2015-03-05T20:02:34Z 2015-03-05 2015-03-05 2015-03-06T02:02:34Z 2015-03-06T02:02:34Z 145576
25 69983322463 Ted Cruz 69983322463_10153664263387464 link Ted Cruz Continues Push for Kate’s Law - Breit... This ought to be a clear choice: With whom do ... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... Sen. Ted Cruz (R-TX) has reintroduced legislat... ... 14844 349 3886.0 2015-10-23T09:38:54Z 2015-10-24T22:28:59Z 2015-10-23 2015-10-24 2015-10-23T14:38:54Z 2015-10-25T03:28:59Z 187490
26 54172246106 Rand Paul 54172246106_10152855748096107 link Rand Paul: Federal Government Has Become ‘Enor... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... Sen. Rand Paul (R-KY), a likely 2016 Republica... ... 14619 665 2802.0 2015-02-21T08:27:57Z 2015-03-02T11:01:11Z 2015-02-21 2015-03-02 2015-02-21T14:27:57Z 2015-03-02T17:01:11Z 12512
27 54172246106 Rand Paul 54172246106_10152822430811107 link "Oh, She’s Going Down": Rand Paul Comes Out S... If you thought Eric Holder was bad... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... Sen. Rand Paul will vote against Loretta Lynch... ... 14561 665 1341.0 2015-02-05T16:37:34Z 2015-02-21T13:49:40Z 2015-02-05 2015-02-21 2015-02-05T22:37:34Z 2015-02-21T19:49:40Z 12512
28 173347701125 Governor Jan Brewer 173347701125_10153906090291126 link Trump Makes Incredible Move to Help Cops Holdi... Donald J. Trump just made an incredible move t... conservativetribune.com https://external.xx.fbcdn.net/safe_image.php?d... http://po.st/ONDn7J The mainstream media won't cover this. ... 14197 427 4326.0 2016-11-15T13:00:00Z 2016-11-17T00:51:56Z 2016-11-15 2016-11-17 2016-11-15T19:00:00Z 2016-11-17T06:51:56Z 233001
29 181888625087 Greg Abbott 181888625087_10156359872620088 link Texas DPS Gets Tip Line to Track Possible Terr... The Texas Department of Public Safety now has ... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1S9oEro The Texas Department of Public Safety (DPS) ha... ... 14186 524 5696.0 2015-12-14T20:32:24Z 2015-12-16T14:42:46Z 2015-12-14 2015-12-16 2015-12-15T02:32:24Z 2015-12-16T20:42:46Z 695877
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1829 995742947182709 Richard Longstreth 995742947182709_1011183865638617 link Result of Third-Party Lawsuit Could Decide Out... "Voter suppression is not about a 98-year-old ... www.breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2016/0... A lawsuit filed on September 26, 2015 in Washi... ... 1 3 1.0 2016-03-09T18:01:28Z 2016-03-10T20:01:06Z 2016-03-09 2016-03-10 2016-03-10T00:01:28Z 2016-03-11T02:01:06Z 10
1830 1432000123682039 Al Hardwick for Congress in Michigan's 5th Dis... 1432000123682039_1802466196635428 link Resettlement Agencies: Increase Middle East-So... This is what this district will be getting und... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2016/0... Breitbart News has obtained the FY 2017 refuge... ... 1 1 1.0 2016-10-18T17:35:31Z 2016-10-19T12:56:05Z 2016-10-18 2016-10-19 2016-10-18T22:35:31Z 2016-10-19T17:56:05Z 10
1831 736011366418469 Ed Rankin for Congress 736011366418469_975611735791763 link Half of Officers Killed by People Barred from ... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... FBI stats show that 26 police officers were sh... ... 0 0 NaN 2015-05-14T21:10:42Z 2015-05-14T21:10:42Z 2015-05-14 2015-05-14 2015-05-15T02:10:42Z 2015-05-15T02:10:42Z 5
1832 250961715499 Paul Chabot for Strong America 250961715499_10156687897360500 link Dem Rep Pushing Background Checks That Already... LIKE NOW if you agree we need leaders who are ... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2016/0... Rep. Mike Thompson (D-CA) is renewing his effo... ... 0 0 0.0 2016-03-21T10:34:28Z 2016-03-21T10:34:28Z 2016-03-21 2016-03-21 2016-03-21T15:34:28Z 2016-03-21T15:34:28Z 109
1833 735648623225176 Dan Hogan for Congress 735648623225176_929392223850814 link Awesome Sh*t My Drill Sergeant Said John McCain, as a Veteran and legitimate forme... NaN https://external.xx.fbcdn.net/safe_image.php?d... http://americanmilitarynews.com/2016/08/bergda... This traitor has some goddamn nerve!\n\nLock h... ... 0 0 NaN 2016-08-04T16:42:32Z 2016-08-04T16:42:32Z 2016-08-04 2016-08-04 2016-08-04T21:42:32Z 2016-08-04T21:42:32Z 1
1834 522549864510526 Andy Whallon for Congress 522549864510526_744684428963734 link GOP Senator Thad Cochran Joins Democrats to Ra... Another disappointment from the Republican lea... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... Several Republican senators—including many who... ... 0 0 0.0 2015-04-15T15:27:13Z 2015-04-15T15:27:13Z 2015-04-15 2015-04-15 2015-04-15T20:27:13Z 2015-04-15T20:27:13Z 0
1835 245385145524887 John Fleming 245385145524887_1018216694908391 link Bernie Sanders Forced Off Seattle Stage By Bla... Socialist Presidential candidate, Bernie Sande... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/2016-presidential-rac... At a Saturday afternoon rally in Seattle, Wash... ... 0 0 NaN 2015-08-08T21:41:04Z 2015-08-08T21:41:04Z 2015-08-08 2015-08-08 2015-08-09T02:41:04Z 2015-08-09T02:41:04Z 11
1836 245385145524887 John Fleming 245385145524887_1110778792318847 link Intel Community Foresees Worst Year Ever for J... Terror activity predicted by intel to only inc... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/national-security/201... The latest annual Worldwide Threat Assessment ... ... 0 1 1.0 2016-02-10T21:43:56Z 2016-02-10T21:43:56Z 2016-02-10 2016-02-10 2016-02-11T03:43:56Z 2016-02-11T03:43:56Z 11
1837 736011366418469 Ed Rankin for Congress 736011366418469_1064306066922329 link Debate Moderators May Try to Sabotage Candidat... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... The debate moderators will promote the free tr... ... 0 0 NaN 2015-11-10T08:51:40Z 2015-11-10T08:51:40Z 2015-11-10 2015-11-10 2015-11-10T14:51:40Z 2015-11-10T14:51:40Z 5
1838 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1010852418943332 link Texas Woman Shoots, Kills Home-Invading Sex Of... NaN breitbart.com https://scontent.xx.fbcdn.net/v/t1.0-0/c48.0.1... http://tinyurl.com/o4jhmq6 A Texas woman home alone shot and killed a sex... ... 0 0 0.0 2015-02-11T20:48:30Z 2015-02-11T20:48:30Z 2015-02-11 2015-02-11 2015-02-12T02:48:30Z 2015-02-12T02:48:30Z 1
1839 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1324160714279166 link DEAR CNN: The Orlando Terrorist Was A Muslim, ... NaN clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/06/dear-cnn-orlando... Progressive heads explode in 3...2...1... ... 0 0 0.0 2016-06-12T13:06:24Z 2016-06-12T13:06:24Z 2016-06-12 2016-06-12 2016-06-12T18:06:24Z 2016-06-12T18:06:24Z 1
1840 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1337675276261043 link Guns And Lace Good guys stopping bad guys isn't news.. Not L... NaN https://scontent.xx.fbcdn.net/v/t45.1600-4/c59... http://conservativetribune.com/another-mass-sh... A good guy with a gun stops a potential "mass ... ... 0 0 0.0 2016-06-30T12:02:30Z 2016-06-30T12:02:30Z 2016-06-30 2016-06-30 2016-06-30T17:02:30Z 2016-06-30T17:02:30Z 1
1841 1263725620325913 Bill Abatecola, R Candidate for US Congress CD3 1263725620325913_1290883637610111 link Faith Matters: POTUS #45 Donald J Trump #goingdown_Hill #Stein4Trump NaN https://external.xx.fbcdn.net/safe_image.php?d... http://www.usapoliticstoday.com/breaking-jill-... #goingdown_Hill #Stein4Trump ... 0 0 NaN 2016-10-12T23:11:47Z 2016-10-12T23:11:47Z 2016-10-12 2016-10-12 2016-10-13T04:11:47Z 2016-10-13T04:11:47Z 0
1842 237760959647650 Robert Pittenger 237760959647650_1093483067408764 link Expert: Latin American Cartels Paying ‘Hezboll... Hezbollah is involved in extortion in every fo... breitbart.com https://external.xx.fbcdn.net/safe_image.php?w... http://www.breitbart.com/national-security/201... Latin American transnational criminal organiza... ... 0 0 1.0 2016-09-08T12:00:47Z 2016-09-08T12:00:47Z 2016-09-08 2016-09-08 2016-09-08T17:00:47Z 2016-09-08T17:00:47Z 19
1843 587534794675887 Mike Kolls for Congress 587534794675887_1082336641862364 link Top Scientist Resigns Admitting Global Warming... It looks like the science is NOW settled. \nht... yournewswire.com https://external.xx.fbcdn.net/safe_image.php?d... http://yournewswire.com/top-scientist-resigns-... Top US scientist Hal Lewis resigned from his p... ... 0 0 NaN 2016-08-19T15:33:05Z 2016-08-19T15:33:05Z 2016-08-19 2016-08-19 2016-08-19T20:33:05Z 2016-08-19T20:33:05Z 2
1844 626152827458075 Cat Ping For Congress 626152827458075_1166916896714996 link Martyred Priest’s Last Words to Jihadists: ‘Be... Gotta say, can't argue with that. Rest in pea... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/2azDDys Just before having his throat slit by two Isla... ... 0 0 NaN 2016-08-04T12:21:52Z 2016-08-04T12:21:52Z 2016-08-04 2016-08-04 2016-08-04T17:21:52Z 2016-08-04T17:21:52Z 24
1845 736011366418469 Ed Rankin for Congress 736011366418469_1176536675699267 link Liberal Hipster Flees Socialist Cali For Capit... NaN prntly.com https://external.xx.fbcdn.net/safe_image.php?d... http://prntly.com/2016/05/11/liberal-hipster-f... AUSTIN, TEXAS- Getting into Austin in his Priu... ... 0 0 1.0 2016-05-15T12:04:43Z 2016-05-15T12:04:43Z 2016-05-15 2016-05-15 2016-05-15T17:04:43Z 2016-05-15T17:04:43Z 5
1846 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1129772490384657 link Boston's Gun Buyback Program Has Taken in One ... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... The failed effort comes as gun crime soars in ... ... 0 0 NaN 2015-08-24T16:35:13Z 2015-08-24T16:35:13Z 2015-08-24 2015-08-24 2015-08-24T21:35:13Z 2015-08-24T21:35:13Z 0
1847 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1354790071216230 link Black Lives Matter Organizer Demands Reparatio... Are you serious? endingthefed.com https://external.xx.fbcdn.net/safe_image.php?d... http://endingthefed.com/black-lives-matter-org... Black Lives Matter has been criticized since i... ... 0 0 NaN 2016-07-22T12:15:14Z 2016-07-22T12:15:14Z 2016-07-22 2016-07-22 2016-07-22T17:15:14Z 2016-07-22T17:15:14Z 0
1848 1559348721058778 Steve Isaacson for Congress 2018 1559348721058778_1562236717436645 link Federal Prosecutor: Obama, Congress Guilty of ... http://beforeitsnews.com/politics/2015/09/obam... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/politics/2015/09/obam... In a interview with Frank Gaffney, Former Fede... ... 0 0 NaN 2016-03-11T07:15:03Z 2016-03-11T07:15:03Z 2016-03-11 2016-03-11 2016-03-11T13:15:03Z 2016-03-11T13:15:03Z 21
1849 736011366418469 Ed Rankin for Congress 736011366418469_1084548774898058 link Paul Ryan's Omnibus Budget Surrenders to EPA R... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/1... Speaker Paul Ryan continues predecessor John B... ... 0 0 3.0 2015-12-22T05:47:54Z 2015-12-22T05:47:54Z 2015-12-22 2015-12-22 2015-12-22T11:47:54Z 2015-12-22T11:47:54Z 5
1850 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1003388923023015 link BREAKING: Here's the "Time Bomb" Obama Has Set... NaN conservativetribune.com https://external.xx.fbcdn.net/safe_image.php?d... http://conservativetribune.com/obama-time-bomb-1/ This is infuriating! ... 0 0 0.0 2015-01-31T04:51:49Z 2015-01-31T04:51:49Z 2015-01-31 2015-01-31 2015-01-31T10:51:49Z 2015-01-31T10:51:49Z 1
1851 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1018200884875152 link Rand Paul: Federal Government Has Become ‘Enor... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... Sen. Rand Paul (R-KY), a likely 2016 Republica... ... 0 0 0.0 2015-02-21T11:17:09Z 2015-02-21T11:17:09Z 2015-02-21 2015-02-21 2015-02-21T17:17:09Z 2015-02-21T17:17:09Z 1
1852 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1032368890125018 link Texas Senators Ignore Moms Demand Action, Pass... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... TX is ignoring Moms Demand Action for Gun Sens... ... 0 0 0.0 2015-03-14T15:39:57Z 2015-03-14T15:39:57Z 2015-03-14 2015-03-14 2015-03-14T20:39:57Z 2015-03-14T20:39:57Z 1
1853 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1352831941412043 link NFL Superstar Just DESTROYED "Black Lives Matt... This is very well said m.facebook.com https://external.xx.fbcdn.net/safe_image.php?d... http://endingthefed.com/nfl-superstar-just-des... Seattle Seahawks cornerback Richard Sherman is... ... 0 0 0.0 2016-07-19T20:49:16Z 2016-07-19T20:49:16Z 2016-07-19 2016-07-19 2016-07-20T01:49:16Z 2016-07-20T01:49:16Z 1
1854 587534794675887 Mike Kolls for Congress 587534794675887_1124324970996864 link Texas Store Employee Uses AK-47 to Stop 4 Arme... To defend Life and Property\nhttp://www.breitb... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/texas/2016/10/04/texa... An employee of a jewelry store in Conroe, Texa... ... 0 0 NaN 2016-10-05T11:54:27Z 2016-10-05T12:04:49Z 2016-10-05 2016-10-05 2016-10-05T16:54:27Z 2016-10-05T17:04:49Z 2
1855 626152827458075 Cat Ping For Congress 626152827458075_1153403161399703 link Globalist Obama: Terrorists, Racist Cops Are '... If you want to be baffled by B.S., then this a... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/2a03Btj Globalist Obama: Terrorists, Racist Cops Are '... ... 0 0 1.0 2016-07-17T06:54:14Z 2016-07-17T06:54:14Z 2016-07-17 2016-07-17 2016-07-17T11:54:14Z 2016-07-17T11:54:14Z 24
1856 811062018922374 Roy Welborn for US Congress Missouri District 5 811062018922374_1343574905671080 link China Plays Hardball… Forces Muslims To Abando... This is very interesting from china\n\nhttp://... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/china-plays-hardball-forces-m... If Muslims think they have it rough in the Uni... ... 0 0 NaN 2016-07-08T09:01:37Z 2016-07-08T09:01:37Z 2016-07-08 2016-07-08 2016-07-08T14:01:37Z 2016-07-08T14:01:37Z 0
1857 1111889342200863 Robert N Marquette for US Senate 1111889342200863_1129937590396038 link GRAPHIC: France ‘Suppressed News’ Of Gruesome ... NaN breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/29LDcQG The French government has been accused of cove... ... 0 0 NaN 2016-07-16T18:16:28Z 2016-07-16T18:16:28Z 2016-07-16 2016-07-16 2016-07-16T23:16:28Z 2016-07-16T23:16:28Z 1
1858 1735878146645132 Matt Orlando for U.S. Congress 2018 1735878146645132_1759617757604504 link Gary Johnson NaN NaN https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/tech/2016/03/23/exclu... Setting aside the question of Apple's security... ... 0 0 NaN 2016-03-29T13:16:33Z 2016-03-29T13:16:33Z 2016-03-29 2016-03-29 2016-03-29T18:16:33Z 2016-03-29T18:16:33Z 1

1859 rows × 21 columns

In [12]:
politician_post_from_all = all_post[all_post.page_name.isin(politician_list)]
politician_post_from_all
Out[12]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_likes post_comments post_shares post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count
3502 5.417225e+10 Rand Paul 54172246106_10153964938326107 status NaN Today the FBI announced Hillary Clinton violat... NaN NaN NaN NaN ... 221159.0 22754.0 285298.0 2016-07-05T12:54:36Z 2016-07-07T10:44:09Z 2016-07-05 2016-07-07 2016-07-05T17:54:36Z 2016-07-07T15:44:09Z 895898.0
3628 1.733477e+11 Governor Jan Brewer 173347701125_10152550765231126 photo Timeline Photos Yesterday, Retired Lt. Cmdr. Joe Langdell, the... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/GovJanBrewer/photos/a... NaN ... 217229.0 19226.0 119056.0 2015-02-05T21:52:27Z 2017-05-08T14:09:57Z 2015-02-05 2017-05-08 2015-02-06T03:52:27Z 2017-05-08T19:09:57Z 58598.0
6248 6.998332e+10 Ted Cruz 69983322463_10154618977607464 status NaN I congratulate President-elect Trump on an ama... NaN NaN NaN NaN ... 164870.0 7568.0 25267.0 2016-11-09T02:07:40Z 2017-02-26T22:38:45Z 2016-11-09 2017-02-26 2016-11-09T08:07:40Z 2017-02-27T04:38:45Z 110117.0
7400 6.998332e+10 Ted Cruz 69983322463_10154486612677464 status NaN Tonight, a clear contrast was drawn between th... NaN NaN NaN NaN ... 149428.0 12290.0 112653.0 2016-09-26T22:15:05Z 2017-05-25T17:08:48Z 2016-09-26 2017-05-25 2016-09-27T03:15:05Z 2017-05-25T22:08:48Z 91122.0
12571 5.417225e+10 Rand Paul 54172246106_10152790068896107 status NaN Mr. President, you can't wave a magic wand and... NaN NaN NaN NaN ... 108413.0 4238.0 14984.0 2015-01-20T20:37:14Z 2015-02-21T17:53:10Z 2015-01-20 2015-02-21 2015-01-21T02:37:14Z 2015-02-21T23:53:10Z 8395.0
13436 6.998332e+10 Ted Cruz 69983322463_10154476728267464 status NaN This election is unlike any other in our natio... NaN NaN NaN NaN ... 104053.0 25471.0 94066.0 2016-09-23T14:24:36Z 2017-05-25T00:25:31Z 2016-09-23 2017-05-25 2016-09-23T19:24:36Z 2017-05-25T05:25:31Z 91122.0
14123 6.998332e+10 Ted Cruz 69983322463_10153049124657464 photo Timeline Photos Texas Governor Greg Abbott has declared Februa... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 100644.0 1430.0 61936.0 2015-02-02T07:38:36Z 2017-02-05T03:40:24Z 2015-02-02 2017-02-05 2015-02-02T13:38:36Z 2017-02-05T09:40:24Z 53911.0
14165 6.998332e+10 Ted Cruz 69983322463_10153184451317464 link Exclusive — Ted Cruz: My First Act As Presiden... If I am elected president, the very first thin... breitbart.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.breitbart.com/big-government/2015/0... Sen. Ted Cruz (R-TX) tells Breitbart News that... ... 100460.0 7730.0 14062.0 2015-04-01T08:50:48Z 2015-04-01T08:50:48Z 2015-04-01 2015-04-01 2015-04-01T13:50:48Z 2015-04-01T13:50:48Z 53911.0
15359 6.998332e+10 Ted Cruz 69983322463_10153710087627464 link Feisty Cruz to Obama: 'Insult Me to My Face,' ... Mr. President, let’s have a debate on Syrian r... nbcnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.nbcnews.com/video/feisty-cruz-to-ob... 2016 Republican presidential candidate Ted Cru... ... 95591.0 7634.0 25077.0 2015-11-18T10:47:24Z 2015-11-20T10:35:10Z 2015-11-18 2015-11-20 2015-11-18T16:47:24Z 2015-11-20T16:35:10Z 388593.0
15604 5.417225e+10 Rand Paul 54172246106_10154306179871107 photo Timeline Photos Thank you all for your support. I'm honored to... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/p130x13... https://www.facebook.com/RandPaul/photos/a.405... NaN ... 94547.0 5766.0 9807.0 2016-11-08T18:12:08Z 2016-11-08T18:12:08Z 2016-11-08 2016-11-08 2016-11-09T00:12:08Z 2016-11-09T00:12:08Z 154035.0
16123 1.733477e+11 Governor Jan Brewer 173347701125_10153543021231126 photo Timeline Photos This morning the United States Supreme Court r... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/GovJanBrewer/photos/a... NaN ... 92551.0 6477.0 53726.0 2016-06-23T10:14:22Z 2017-02-14T11:16:43Z 2016-06-23 2017-02-14 2016-06-23T15:14:22Z 2017-02-14T17:16:43Z 57518.0
16324 6.998332e+10 Ted Cruz 69983322463_10153725637517464 photo Photos from Ted Cruz's post Thankful for time with the family this Thanksg... NaN https://scontent.xx.fbcdn.net/hphotos-xat1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 91787.0 2332.0 4579.0 2015-11-26T17:40:09Z 2015-11-28T04:18:12Z 2015-11-26 2015-11-28 2015-11-26T23:40:09Z 2015-11-28T10:18:12Z 231800.0
16514 6.998332e+10 Ted Cruz 69983322463_10153633017117464 photo Timeline Photos As Texas Solicitor General, I had the great ho... NaN https://scontent.xx.fbcdn.net/hphotos-xla1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 91125.0 6584.0 24895.0 2015-10-06T09:34:36Z 2015-10-08T07:38:00Z 2015-10-06 2015-10-08 2015-10-06T14:34:36Z 2015-10-08T12:38:00Z 238393.0
16999 1.733477e+11 Governor Jan Brewer 173347701125_10152778930981126 photo Timeline Photos Great news earlier today when a federal court ... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/GovJanBrewer/photos/a... NaN ... 89442.0 2606.0 10601.0 2015-05-26T20:06:00Z 2016-02-11T01:27:04Z 2015-05-26 2016-02-11 2015-05-27T01:06:00Z 2016-02-11T07:27:04Z 57551.0
18957 6.998332e+10 Ted Cruz 69983322463_10153928288217464 photo Timeline Photos Thank you Texas! #ChooseCruz NaN https://scontent.xx.fbcdn.net/hphotos-xtf1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 83474.0 6172.0 15040.0 2016-03-01T20:03:09Z 2016-03-03T19:09:15Z 2016-03-01 2016-03-03 2016-03-02T02:03:09Z 2016-03-04T01:09:15Z 394971.0
20284 1.733477e+11 Governor Jan Brewer 173347701125_10152491917216126 photo Timeline Photos It's truly been an honor serving as Arizona's ... NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/GovJanBrewer/photos/a... NaN ... 79941.0 11163.0 2800.0 2015-01-02T22:57:39Z 2015-12-15T12:36:21Z 2015-01-02 2015-12-15 2015-01-03T04:57:39Z 2015-12-15T18:36:21Z 57551.0
20680 5.417225e+10 Rand Paul 54172246106_10153161560311107 photo NaN NaN NaN https://scontent.xx.fbcdn.net/hphotos-xpf1/v/t... https://www.facebook.com/RandPaul/photos/a.101... NaN ... 78934.0 1118.0 16745.0 2015-06-28T22:25:49Z 2015-06-30T20:44:56Z 2015-06-28 2015-06-30 2015-06-29T03:25:49Z 2015-07-01T01:44:56Z 149737.0
20836 6.998332e+10 Ted Cruz 69983322463_10153945965862464 link Carly Fiorina Endorses Ted Cruz for President ... I'm honored to earn the endorsement of Carly F... tedcruz.org https://external.xx.fbcdn.net/safe_image.php?d... https://www.tedcruz.org/news/carly-fiorina-end... MIAMI, FL – Presidential Candidate Ted Cruz an... ... 78567.0 5289.0 10397.0 2016-03-09T09:45:44Z 2016-03-09T09:45:44Z 2016-03-09 2016-03-09 2016-03-09T15:45:44Z 2016-03-09T15:45:44Z 727594.0
20883 5.417225e+10 Rand Paul 54172246106_10153544918351107 status NaN President Obama's executive actions to put res... NaN NaN NaN NaN ... 78442.0 3297.0 21757.0 2016-01-03T15:59:19Z 2016-01-05T07:44:22Z 2016-01-03 2016-01-05 2016-01-03T21:59:19Z 2016-01-05T13:44:22Z 95217.0
21424 6.998332e+10 Ted Cruz 69983322463_10154254165982464 link Ted Cruz says he has 'serious concerns' about ... While I have tremendous respect for the dedica... businessinsider.com https://external.xx.fbcdn.net/safe_image.php?w... http://www.businessinsider.com/ted-cruz-fbi-di... Ted Cruz called for “full access” to “all the ... ... 77200.0 5724.0 15895.0 2016-07-05T17:45:36Z 2016-10-10T23:47:22Z 2016-07-05 2016-10-10 2016-07-05T22:45:36Z 2016-10-11T04:47:22Z 91122.0
21519 6.998332e+10 Ted Cruz 69983322463_10153724760487464 link This Thanksgiving we celebrate the blessings t... On this Thanksgiving, as we gather with family... tedcruz.org https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1TgORoZ HOUSTON, Texas — Presidential candidate Ted Cr... ... 76989.0 3447.0 7560.0 2015-11-26T08:27:13Z 2015-11-28T02:29:41Z 2015-11-26 2015-11-28 2015-11-26T14:27:13Z 2015-11-28T08:29:41Z 231800.0
21527 6.998332e+10 Ted Cruz 69983322463_10153777717527464 photo Timeline Photos Seems like a better idea for a cartoon: Hillar... NaN https://scontent.xx.fbcdn.net/hphotos-xfa1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 76975.0 3857.0 19240.0 2015-12-23T13:47:36Z 2015-12-25T12:20:58Z 2015-12-23 2015-12-25 2015-12-23T19:47:36Z 2015-12-25T18:20:58Z 259049.0
22582 6.998332e+10 Ted Cruz 69983322463_10153638995517464 photo Ted Cruz My thoughts and prayers are with the Israeli p... NaN https://fbcdn-photos-f-a.akamaihd.net/hphotos-... https://www.facebook.com/tedcruzpage/photos/a.... SHARE if you agree we need a President who wil... ... 74529.0 2037.0 27.0 2015-10-09T17:04:28Z 2015-10-11T15:25:25Z 2015-10-09 2015-10-11 2015-10-09T22:04:28Z 2015-10-11T20:25:25Z 298295.0
22789 6.998332e+10 Ted Cruz 69983322463_10153937295612464 photo Timeline Photos Thank you Kansas! Help us #CruzToVictory —> ht... NaN https://scontent.xx.fbcdn.net/hphotos-xtp1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 74097.0 4068.0 10410.0 2016-03-05T16:42:34Z 2016-03-07T11:59:05Z 2016-03-05 2016-03-07 2016-03-05T22:42:34Z 2016-03-07T17:59:05Z 677437.0
23954 6.998332e+10 Ted Cruz 69983322463_10153862221417464 photo Timeline Photos Thank you Iowa! This is OUR time. Join us: ted... NaN https://scontent.xx.fbcdn.net/hphotos-xft1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 71710.0 7032.0 10484.0 2016-02-01T22:26:11Z 2016-02-03T21:43:12Z 2016-02-01 2016-02-03 2016-02-02T04:26:11Z 2016-02-04T03:43:12Z 336380.0
24970 6.998332e+10 Ted Cruz 69983322463_10153932390137464 photo Timeline Photos As president, I'll defend the Second Amendment... NaN https://scontent.xx.fbcdn.net/hphotos-xpl1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 69834.0 1860.0 14230.0 2016-03-03T16:43:29Z 2016-03-05T03:35:36Z 2016-03-03 2016-03-05 2016-03-03T22:43:29Z 2016-03-05T09:35:36Z 548635.0
25239 5.417225e+10 Rand Paul 54172246106_10153137246471107 status NaN I'm ready to drive a stake through the heart o... NaN NaN NaN NaN ... 69358.0 3572.0 14328.0 2015-06-18T15:14:43Z 2015-06-20T12:33:44Z 2015-06-18 2015-06-20 2015-06-18T20:14:43Z 2015-06-20T17:33:44Z 113994.0
25538 6.998332e+10 Ted Cruz 69983322463_10153596434802464 photo Timeline Photos This is what I'll do if elected President. \n\... NaN https://fbcdn-photos-a-a.akamaihd.net/hphotos-... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 68821.0 2569.0 18889.0 2015-09-17T08:31:04Z 2015-09-18T13:39:16Z 2015-09-17 2015-09-18 2015-09-17T13:31:04Z 2015-09-18T18:39:16Z 229904.0
25667 6.998332e+10 Ted Cruz 69983322463_10153928392802464 photo Republican Party of Texas NaN NaN https://scontent.xx.fbcdn.net/hphotos-xtf1/v/t... https://www.facebook.com/RepublicanPartyofTexa... Congratulations to our Senator, Ted Cruz, for ... ... 68589.0 2446.0 4.0 2016-03-01T20:52:34Z 2016-03-03T19:30:09Z 2016-03-01 2016-03-03 2016-03-02T02:52:34Z 2016-03-04T01:30:09Z 394971.0
25677 5.417225e+10 Rand Paul 54172246106_10153514013306107 link Paul: Nobody read the $1.1 trillion omnibus bill "It was over a trillion dollars, it was all lu... thehill.com https://external.xx.fbcdn.net/safe_image.php?d... http://thehill.com/blogs/blog-briefing-room/ne... “I voted against it because I won’t vote for t... ... 68576.0 4196.0 30327.0 2015-12-20T07:37:51Z 2015-12-20T07:37:51Z 2015-12-20 2015-12-20 2015-12-20T13:37:51Z 2015-12-20T13:37:51Z 219337.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
11273060 6.998332e+10 Ted Cruz 69983322463_10153816586742464 photo Timeline Photos Thank you #CruzCrew for joining #CruzinToCaucu... NaN https://scontent.xx.fbcdn.net/hphotos-xaf1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 25.0 2.0 2.0 2016-01-10T15:03:05Z 2016-01-10T15:05:18Z 2016-01-10 2016-01-10 2016-01-10T21:03:05Z 2016-01-10T21:05:18Z 213325.0
11278651 5.417225e+10 Rand Paul 54172246106_10153293280766107 link Record Your Rand Paul Endorsement Video Today! Iowa, I need your help. Will you take a couple... s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 25.0 2.0 3.0 2015-08-22T14:09:00Z 2015-08-24T10:51:39Z 2015-08-22 2015-08-24 2015-08-22T19:09:00Z 2015-08-24T15:51:39Z 74799.0
11283707 5.417225e+10 Rand Paul 54172246106_10153194916236107 link Record Your Rand Paul Endorsement Video Today! Iowa, take a few minutes and tell us why you s... s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 25.0 4.0 NaN 2015-07-12T14:37:01Z 2015-07-13T12:05:11Z 2015-07-12 2015-07-13 2015-07-12T19:37:01Z 2015-07-13T17:05:11Z 147920.0
11292642 5.417225e+10 Rand Paul 54172246106_10153231850381107 link Record Your Rand Paul Endorsement Video Today! Wyoming, SHARE if you stand with Rand! s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 25.0 3.0 5.0 2015-07-25T15:02:00Z 2015-07-25T17:40:28Z 2015-07-25 2015-07-25 2015-07-25T20:02:00Z 2015-07-25T22:40:28Z 162225.0
11295667 5.417225e+10 Rand Paul 54172246106_10153349413256107 link Record Your Rand Paul Endorsement Video Today! New Hampshire, will you take 5 minutes to reco... s.heyo.com https://external.xx.fbcdn.net/safe_image.php?d... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 25.0 3.0 NaN 2015-09-14T10:51:01Z 2015-09-14T16:26:04Z 2015-09-14 2015-09-14 2015-09-14T15:51:01Z 2015-09-14T21:26:04Z 95035.0
11297760 1.733477e+11 Governor Jan Brewer 173347701125_10153741930366126 photo Governor Jan Brewer's cover photo NaN NaN https://scontent.xx.fbcdn.net/v/t1.0-0/s130x13... https://www.facebook.com/GovJanBrewer/photos/a... NaN ... 25.0 5.0 2.0 2016-09-15T11:20:57Z 2016-09-16T22:02:15Z 2016-09-15 2016-09-16 2016-09-15T16:20:57Z 2016-09-17T03:02:15Z 14140.0
11299660 5.417225e+10 Rand Paul 54172246106_10153375997451107 link Wyoming - Contribute Today! Wyoming, I need you to step up immediately and... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBWyoming Rand Paul for President: Defeat the Washington... ... 25.0 2.0 1.0 2015-09-28T13:30:57Z 2015-09-28T20:06:12Z 2015-09-28 2015-09-28 2015-09-28T18:30:57Z 2015-09-29T01:06:12Z 126748.0
11308393 5.417225e+10 Rand Paul 54172246106_10153320988396107 link Record Your Rand Paul Endorsement Video Today! Nevada, why do you stand with Rand? Take a few... s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 25.0 2.0 NaN 2015-09-02T12:51:01Z 2015-09-03T18:01:52Z 2015-09-02 2015-09-03 2015-09-02T17:51:01Z 2015-09-03T23:01:52Z 92496.0
11330002 5.417225e+10 Rand Paul 54172246106_10153231794696107 link Record Your Rand Paul Endorsement Video Today! Nevada, SHARE if you stand with Rand! s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 24.0 2.0 2.0 2015-07-25T15:02:00Z 2015-07-25T16:53:31Z 2015-07-25 2015-07-25 2015-07-25T20:02:00Z 2015-07-25T21:53:31Z 170396.0
11372980 5.417225e+10 Rand Paul 54172246106_10153375840766107 link Alaska - Contribute Today! Alaska, I need you to step up immediately and ... secure.randpaul.com https://external.xx.fbcdn.net/safe_image.php?d... https://secure.randpaul.com/?sr=HMFBAlaska Rand Paul for President: Defeat the Washington... ... 24.0 3.0 1.0 2015-09-28T11:55:14Z 2015-09-28T20:56:17Z 2015-09-28 2015-09-28 2015-09-28T16:55:14Z 2015-09-29T01:56:17Z 126748.0
11412640 5.417225e+10 Rand Paul 54172246106_10153376201331107 link Maryland - Contribute Today! Maryland, I need you to step up immediately an... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBMaryland Rand Paul for President: Defeat the Washington... ... 23.0 4.0 7.0 2015-09-28T16:39:14Z 2015-09-28T17:19:58Z 2015-09-28 2015-09-28 2015-09-28T21:39:14Z 2015-09-28T22:19:58Z 126748.0
11418171 5.417225e+10 Rand Paul 54172246106_10153248136526107 link Record Your Rand Paul Endorsement Video Today! New Hampshire, be the star of our next web vid... s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 23.0 2.0 1.0 2015-08-02T19:26:00Z 2015-08-04T06:57:53Z 2015-08-02 2015-08-04 2015-08-03T00:26:00Z 2015-08-04T11:57:53Z 148527.0
11493815 5.417225e+10 Rand Paul 54172246106_10153376210321107 link Mississippi - Contribute Today! Mississippi, I need you to step up immediately... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBMississippi Rand Paul for President: Defeat the Washington... ... 22.0 1.0 2.0 2015-09-28T16:47:57Z 2015-09-28T17:18:43Z 2015-09-28 2015-09-28 2015-09-28T21:47:57Z 2015-09-28T22:18:43Z 126748.0
11521134 5.417225e+10 Rand Paul 54172246106_10153375897551107 link Vermont - Contribute Today! Vermont, I need you to step up immediately and... secure.randpaul.com https://external.xx.fbcdn.net/safe_image.php?d... https://secure.randpaul.com/?sr=HMFBVermont Rand Paul for President: Defeat the Washington... ... 22.0 1.0 2.0 2015-09-28T12:35:56Z 2015-09-28T17:24:54Z 2015-09-28 2015-09-28 2015-09-28T17:35:56Z 2015-09-28T22:24:54Z 126748.0
11532907 5.417225e+10 Rand Paul 54172246106_10153376040581107 link Hawaii - Contribute Today! Hawaii, I need you to step up immediately and ... secure.randpaul.com https://external.xx.fbcdn.net/safe_image.php?d... https://secure.randpaul.com/?sr=HMFBHawaii Rand Paul for President: Defeat the Washington... ... 22.0 3.0 5.0 2015-09-28T14:05:05Z 2015-09-29T02:42:27Z 2015-09-28 2015-09-29 2015-09-28T19:05:05Z 2015-09-29T07:42:27Z 126748.0
11578491 5.417225e+10 Rand Paul 54172246106_10153376017966107 link Delaware - Contribute Today! Delaware, I need you to step up immediately an... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBDelaware Rand Paul for President: Defeat the Washington... ... 21.0 1.0 1.0 2015-09-28T13:43:21Z 2015-09-28T17:22:38Z 2015-09-28 2015-09-28 2015-09-28T18:43:21Z 2015-09-28T22:22:38Z 126748.0
11586690 5.417225e+10 Rand Paul 54172246106_10153375870266107 link Colorado - Contribute Today! Colorado, I need you to step up immediately an... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBColorado Rand Paul for President: Defeat the Washington... ... 21.0 1.0 3.0 2015-09-28T12:14:56Z 2015-09-28T17:27:49Z 2015-09-28 2015-09-28 2015-09-28T17:14:56Z 2015-09-28T22:27:49Z 126748.0
11631338 5.417225e+10 Rand Paul 54172246106_10153375870421107 link Rhode Island - Contribute Today! Rhode Island, I need you to step up immediatel... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBRhodeIsland Rand Paul for President: Defeat the Washington... ... 20.0 4.0 9.0 2015-09-28T12:15:06Z 2015-09-28T17:27:33Z 2015-09-28 2015-09-28 2015-09-28T17:15:06Z 2015-09-28T22:27:33Z 126748.0
11661297 5.417225e+10 Rand Paul 54172246106_10153230511276107 link Record Your Rand Paul Endorsement Video Today! New Hampshire, tell us why you stand with Rand... s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 20.0 5.0 2.0 2015-07-24T19:23:00Z 2015-07-25T00:31:00Z 2015-07-24 2015-07-25 2015-07-25T00:23:00Z 2015-07-25T05:31:00Z 174826.0
11721293 5.417225e+10 Rand Paul 54172246106_10153375881596107 link South Dakota - Contribute Today! South Dakota, I need you to step up immediatel... secure.randpaul.com https://external.xx.fbcdn.net/safe_image.php?d... https://secure.randpaul.com/?sr=HMFBSouthDakota Rand Paul for President: Defeat the Washington... ... 19.0 2.0 NaN 2015-09-28T12:22:06Z 2015-09-29T21:18:19Z 2015-09-28 2015-09-29 2015-09-28T17:22:06Z 2015-09-30T02:18:19Z 126748.0
11760936 5.417225e+10 Rand Paul 54172246106_10153066162211107 photo NaN We hope you'll join Sen. Rand Paul at the DuPa... NaN https://scontent.xx.fbcdn.net/hphotos-xpf1/v/t... https://www.facebook.com/RandPaul/photos/a.405... NaN ... 19.0 6.0 NaN 2015-05-21T12:57:16Z 2015-05-21T13:09:30Z 2015-05-21 2015-05-21 2015-05-21T17:57:16Z 2015-05-21T18:09:30Z 96422.0
11851831 5.417225e+10 Rand Paul 54172246106_10153375855026107 link North Dakota - Contribute Today! North Dakota, I need you to step up immediatel... secure.randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... https://secure.randpaul.com/?sr=HMFBNorthDakota Rand Paul for President: Defeat the Washington... ... 18.0 2.0 NaN 2015-09-28T12:00:20Z 2015-09-28T17:29:06Z 2015-09-28 2015-09-28 2015-09-28T17:00:20Z 2015-09-28T22:29:06Z 126748.0
11896606 6.998332e+10 Ted Cruz 69983322463_10153805663857464 photo Timeline Photos Be sure to follow behind the scenes from our #... NaN https://scontent.xx.fbcdn.net/hphotos-xft1/v/t... https://www.facebook.com/tedcruzpage/photos/a.... NaN ... 17.0 4.0 NaN 2016-01-04T20:24:09Z 2016-01-04T20:29:06Z 2016-01-04 2016-01-04 2016-01-05T02:24:09Z 2016-01-05T02:29:06Z 218603.0
11984682 5.417225e+10 Rand Paul 54172246106_10153231803506107 link Record Your Rand Paul Endorsement Video Today! New Hampshire, SHARE if you stand with Rand! s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 16.0 1.0 2.0 2015-07-25T15:02:00Z 2015-07-25T16:52:29Z 2015-07-25 2015-07-25 2015-07-25T20:02:00Z 2015-07-25T21:52:29Z 162225.0
12012973 5.417225e+10 Rand Paul 54172246106_10153375829336107 link Alabama - Contribute Today! Alabama, I need you to step up immediately and... secure.randpaul.com https://external.xx.fbcdn.net/safe_image.php?d... https://secure.randpaul.com/?sr=HMFBAlabama Rand Paul for President: Defeat the Washington... ... 16.0 1.0 3.0 2015-09-28T11:51:34Z 2015-09-28T17:30:58Z 2015-09-28 2015-09-28 2015-09-28T16:51:34Z 2015-09-28T22:30:58Z 126748.0
12224765 6.998332e+10 Ted Cruz 69983322463_10153920455092464 video Ted Cruz True or false, Donald J. Trump?\n\n#ChooseCruz... NaN https://scontent.xx.fbcdn.net/hvthumb-xat1/v/t... https://www.facebook.com/tedcruzpage/videos/10... As president, I'll fight for a #FullRepeal of ... ... 14.0 2.0 NaN 2016-02-27T12:25:19Z 2016-02-27T12:26:11Z 2016-02-27 2016-02-27 2016-02-27T18:25:19Z 2016-02-27T18:26:11Z 326161.0
12684537 5.417225e+10 Rand Paul 54172246106_10153231763036107 link Record Your Rand Paul Endorsement Video Today! Montana, SHARE if you stand with Rand! s.heyo.com https://fbexternal-a.akamaihd.net/safe_image.p... http://s.heyo.com/344a40 Become the star of our next online video! Tell... ... 10.0 0.0 1.0 2015-07-25T15:02:00Z 2015-07-25T15:02:00Z 2015-07-25 2015-07-25 2015-07-25T20:02:00Z 2015-07-25T20:02:00Z 174826.0
12971054 1.733477e+11 Governor Jan Brewer 173347701125_10154235292196126 video Conservative Tribune In case you missed me on Wednesday - I was on ... NaN https://scontent.xx.fbcdn.net/v/t15.0-10/s130x... https://www.facebook.com/theconservativetribun... CT-TV with Rusty Humphries is LIVE! Special gu... ... 8.0 1.0 NaN 2017-03-17T14:30:00Z 2017-03-17T16:05:02Z 2017-03-17 2017-03-17 2017-03-17T19:30:00Z 2017-03-17T21:05:02Z 61176.0
13570536 5.417225e+10 Rand Paul 54172246106_10153047084666107 link Meet Rand Paul in Iowa | RSVP Here I'll be at Oskaloosa's Smokey Row Coffee Shop ... randpaul.com https://fbexternal-a.akamaihd.net/safe_image.p... http://randpaul.com/oskaloosa-event-05162015 Rand Paul for President: Defeat the Washington... ... 4.0 6.0 1.0 2015-05-12T17:05:25Z 2015-05-12T17:33:56Z 2015-05-12 2015-05-12 2015-05-12T22:05:25Z 2015-05-12T22:33:56Z 153191.0
14637283 5.417225e+10 Rand Paul 54172246106_10153116776101107 link Stand With Rand Meet & Greet - Lexington, SC ... I hope you'll join me for a Stand With Rand Me... eventbrite.com https://fbexternal-a.akamaihd.net/safe_image.p... https://www.eventbrite.com/e/stand-with-rand-m... Join Senator Rand Paul for a special meet & gr... ... 0.0 1.0 NaN 2015-06-09T17:13:31Z 2015-06-09T17:13:31Z 2015-06-09 2015-06-09 2015-06-09T22:13:31Z 2015-06-09T22:13:31Z 263500.0

9163 rows × 21 columns

Fake News Analysis

seperate by category

In [13]:
pageinfo_separate_by_cat = pageinfo.groupby('category').mean()
pageinfo_separate_by_cat = pageinfo_separate_by_cat[['total_like','total_comment','total_share','fan_count']]
pageinfo_separate_by_cat['page_num'] = pageinfo.groupby('category').size()
In [14]:
politifact_separate_by_cat = politifact_with_fake_domain.groupby('category').mean()
politifact_separate_by_cat = politifact_separate_by_cat[['post_reactions','post_likes','post_comments','post_shares','page_talking_about_count']]
politifact_separate_by_cat['count'] = politifact_with_fake_domain.groupby('category').size()
politifact_separate_by_cat['page_num'] = politifact_with_fake_domain.groupby(['category','page_name']).size().reset_index().groupby('category').size()
politifact_separate_by_cat = politifact_separate_by_cat[politifact_separate_by_cat['count']>90]
politifact_separate_by_cat.sort_values('count')
Out[14]:
post_reactions post_likes post_comments post_shares page_talking_about_count count page_num
category
Organization 742.393939 287.479167 71.552083 338.600000 4.965308e+04 96 2
Arts/Humanities Website 829.888889 700.762887 76.103093 304.968750 4.512231e+05 97 1
Education 195.031250 110.432584 15.797753 134.902098 5.513023e+04 178 3
Political Organization 499.842975 381.148571 104.131429 429.902685 1.595614e+05 350 14
Musician/Band 2144.972028 1556.852273 296.059659 2155.670455 1.256542e+07 352 2
Website 1073.092784 786.185819 87.520782 356.331633 3.996985e+05 409 4
Society/Culture Website 915.402985 815.295880 129.157303 441.550562 1.107704e+05 534 2
Personal Blog 333.233108 275.406932 64.798460 168.778271 5.524922e+04 779 2
Non-Governmental Organization (NGO) 235.392357 168.049682 42.351592 98.579421 3.385693e+04 1570 1
Journalist 24.344520 32.268938 6.018342 20.920854 3.241681e+04 4198 3
Just For Fun 101.338462 73.511339 18.390850 40.362968 2.543958e+04 5071 1
Public Figure 1403.603015 1035.955148 182.337173 439.880175 3.775713e+05 5730 17
Publisher 225.992290 155.677253 40.911921 76.551963 2.465086e+04 6392 1
Cause 67.893318 59.693882 16.752877 32.982930 1.755764e+04 8255 3
Politician 95.750403 42.280969 8.456996 50.007389 1.877585e+04 12464 5
Community 923.746053 751.328808 191.561406 547.583880 2.364749e+05 12743 47
Media/News/Publishing 2268.661361 1759.074841 265.371396 871.017663 3.164316e+05 19214 23
News/Media Website 738.892600 369.993087 101.120265 327.992299 3.896767e+05 53665 23

seperate by type

In [15]:
pageinfo_separate_by_type = pageinfo.groupby('type').mean()
pageinfo_separate_by_type = pageinfo_separate_by_type[['total_like','total_comment','total_share','fan_count']]
pageinfo_separate_by_type['page_num'] = pageinfo.groupby('type').size()
In [16]:
politifact_separate_by_type = politifact_with_fake_domain.groupby('type').mean()
politifact_separate_by_type = politifact_separate_by_type[['post_reactions','post_likes','post_comments','post_shares','page_talking_about_count']]
politifact_separate_by_type['count'] = politifact_with_fake_domain.groupby('type').size()
politifact_separate_by_type['page_num'] = politifact_with_fake_domain.groupby(['type','page_name']).size().reset_index().groupby('type').size()
politifact_separate_by_type
Out[16]:
post_reactions post_likes post_comments post_shares page_talking_about_count count page_num
type
figure 482.353943 336.531283 78.051039 194.284932 1.461013e+05 16223 24
group 581.435492 444.999275 100.825327 279.041251 1.170871e+05 31745 92
media 1227.113731 641.382905 125.076634 420.594803 3.221109e+05 83710 56
others 1559.808824 883.352396 165.001546 1236.947702 6.871414e+06 647 5

fake domain analysis

In [17]:
politifact_separate_by_domain = politifact_with_fake_domain.groupby('domain').mean()
politifact_separate_by_domain.sort_values('post_likes')
domain_list = politifact_separate_by_domain.index.tolist()
domain_list
Out[17]:
['247NewsMedia.com',
 'ANews24.org',
 'AmericanPoliticNews.co',
 'AngryPatriotMovement.com',
 'BB4SP.com',
 'BeforeItsNews.com',
 'BuzzFeedUSA.com',
 'CivicTribune.com',
 'ClashDaily.com',
 'ConservativeDailyPost.com',
 'ConservativeSpirit.com',
 'DailyNewsPosts.info',
 'DailySurge.com',
 'DemocraticMoms.com',
 'Disclose.tv',
 'DonaldTrumpPOTUS45.com',
 'En-Volve.com',
 'FederalistTribune.com',
 'FedsAlert.com',
 'FreedomDaily.com',
 'FreedomsFinalStand.com',
 'GiveMeLiberty01.com',
 'GummyPost.com',
 'HealthyWorldHouse.com',
 'LastDeplorables.com',
 'LiberalPlug.com',
 'Liberty-Courier.com',
 'LibertyAlliance.com',
 'MadWorldNews.com',
 'NeonNettle.com',
 'NewPoliticsToday.com',
 'NewsBreaksHere.com',
 'NewsExaminer.net',
 'NewzMagazine.com',
 'NotAllowedTo.com',
 'OnePoliticalPlaza.com',
 'PoliticsUSANews.com',
 'President45DonaldTrump.com',
 'Prntly.com',
 'ReadConservatives.news',
 'RedCountry.us',
 'ReligionMind.com',
 'Spinzon.com',
 'SupremePatriot.com',
 'TDTAlliance.com',
 'TMZWorldNews.com',
 'The-Insider.co',
 'TheTrumpMedia.com',
 'TrueAmericans.me',
 'USADailyInfo.com',
 'USADailyTime.com',
 'USANewsHome.com',
 'USAPolitics24hrs.com',
 'USAPoliticsNow.com',
 'USAPoliticsToday.com',
 'USASnich.com',
 'USHealthyAdvisor.com',
 'USHerald.com',
 'USInfoNews.com',
 'USPOLN.com',
 'USPostman.com',
 'UndergroundNewsReport.com',
 'UniversePolitics.com',
 'VoxTribune.com',
 'WashingtonFeed.com']
In [18]:
domain_page_relation = politifact_with_fake_domain.groupby(['domain','page_name']).size()
domain_page_relation = domain_page_relation.reset_index()
domain_page_relation
Out[18]:
domain page_name 0
0 247NewsMedia.com America Elects a Leader president 1
1 ANews24.org American's Who Stand For America 83
2 ANews24.org Anonymous The World is Ours 1
3 ANews24.org Democrats Driving Forward to Victory 42
4 ANews24.org Donald Trump, The Political Movement 1
5 ANews24.org Prepare to Take America Back 1
6 ANews24.org Reclaim America 1
7 AmericanPoliticNews.co Ann Romney Fan Site 1
8 AmericanPoliticNews.co Conservatives Against Obama's Liberal Agenda 1
9 AmericanPoliticNews.co One Nation Under God 2
10 AmericanPoliticNews.co Rick Joyner 1
11 AmericanPoliticNews.co The Last Great Stand 1
12 AngryPatriotMovement.com America Needs a Truthful president 2
13 AngryPatriotMovement.com American's Who Stand For America 64
14 AngryPatriotMovement.com Americans Who Stand For America 2
15 AngryPatriotMovement.com Angry American Patriots 2
16 AngryPatriotMovement.com Ann Romney Fan Site 30
17 AngryPatriotMovement.com Anonymous The World is Ours 1
18 AngryPatriotMovement.com Being Libtarded 1
19 AngryPatriotMovement.com CJ Pearson 1
20 AngryPatriotMovement.com Craig "Sawman" Sawyer 2
21 AngryPatriotMovement.com Donald Trump, The Political Movement 33
22 AngryPatriotMovement.com Last American Patriots 6
23 AngryPatriotMovement.com Law Enforcement Today 1
24 AngryPatriotMovement.com One Nation Under God 6
25 AngryPatriotMovement.com Political Correctness Gone Wild 9
26 AngryPatriotMovement.com Reclaim America 103
27 AngryPatriotMovement.com Red White Blue News 1
28 AngryPatriotMovement.com THE GREAT AWAKENING 3
29 AngryPatriotMovement.com The Alex Jones Channel 3
... ... ... ...
715 USHerald.com The Revolution 111
716 USHerald.com Wayne Allyn Root 1
717 USHerald.com Wayne Dupree Show 2
718 USHerald.com WikiLeaks Updates 1
719 USInfoNews.com Anonymous The World is Ours 1
720 USInfoNews.com THE GREAT AWAKENING 1
721 USPOLN.com Bob The Wonder Poodle 1
722 USPOLN.com God Emperor Trump 1
723 USPOLN.com Reclaim America 1
724 USPOLN.com The Party of Scrooge - History of American Pol... 1
725 USPostman.com Conservatives Against A Liberal Agenda 2
726 UndergroundNewsReport.com America Elects a Leader president 1
727 UndergroundNewsReport.com Anonymous The World is Ours 1
728 UndergroundNewsReport.com Illuminati Exposed (This is the resistance) 1
729 UniversePolitics.com Anonymous The World is Ours 1
730 UniversePolitics.com Bernie Sanders' Supporters 3
731 UniversePolitics.com Conservatives Against Obama's Liberal Agenda 1
732 UniversePolitics.com Hillary Clinton 2016 1
733 UniversePolitics.com Hillary Clinton Sucks 1
734 UniversePolitics.com One Liberal's SLANT on Politics 1
735 UniversePolitics.com Political Correctness Gone Wild 1
736 UniversePolitics.com Rude and Rotten Republicans 1
737 UniversePolitics.com The Middle Class Will Be Heard 1
738 UniversePolitics.com The Witty Liberal 2
739 VoxTribune.com America Elects a Leader president 2
740 VoxTribune.com Reclaim America 1
741 WashingtonFeed.com Contra Culture 1
742 WashingtonFeed.com End The Fed 1570
743 WashingtonFeed.com Michael Savage-Fan Made Page 2
744 WashingtonFeed.com Reclaim America 1

745 rows × 3 columns

In [19]:
fake_domain = politifact_with_fake_domain.groupby('domain').mean()
fake_domain = fake_domain[['post_likes','post_comments','post_shares']]
fake_domain['count'] = politifact_with_fake_domain.groupby('domain').size()
fake_domain.sort_values('count')
Out[19]:
post_likes post_comments post_shares count
domain
247NewsMedia.com 178.000000 18.000000 62.000000 1
GiveMeLiberty01.com 8.000000 6.000000 6.000000 1
FederalistTribune.com 719.000000 132.000000 295.000000 1
PoliticsUSANews.com 1158.000000 697.000000 359.000000 1
RedCountry.us 595.000000 643.000000 838.000000 1
ReligionMind.com 446.000000 207.000000 615.000000 1
USASnich.com 261.000000 60.000000 148.000000 1
ConservativeSpirit.com 57.000000 5.000000 46.000000 1
LastDeplorables.com 341.000000 186.000000 132.000000 1
NewzMagazine.com 233.000000 48.000000 671.000000 2
OnePoliticalPlaza.com 7.000000 2.000000 7.000000 2
DemocraticMoms.com 122.500000 38.500000 222.000000 2
TheTrumpMedia.com 66.500000 11.000000 41.500000 2
USAPolitics24hrs.com 1757.000000 133.000000 1750.500000 2
BuzzFeedUSA.com 208.000000 644.000000 307.000000 2
USInfoNews.com 147.500000 8.000000 191.000000 2
USPostman.com 3196.000000 411.500000 1251.500000 2
NewPoliticsToday.com 718.000000 560.000000 5113.500000 2
CivicTribune.com 167.666667 76.666667 430.500000 3
USHealthyAdvisor.com 1774.666667 608.666667 1365.000000 3
NotAllowedTo.com 120.333333 100.000000 542.666667 3
UndergroundNewsReport.com 302.000000 41.333333 246.333333 3
GummyPost.com 1545.333333 598.000000 2469.000000 3
VoxTribune.com 33.333333 15.333333 80.000000 3
USPOLN.com 1776.000000 249.500000 1348.500000 4
USADailyTime.com 359.000000 32.500000 229.000000 4
NewsExaminer.net 125.500000 37.000000 177.000000 4
TDTAlliance.com 267.800000 134.800000 504.400000 5
AmericanPoliticNews.co 1693.333333 731.833333 1855.000000 6
ReadConservatives.news 140.666667 14.666667 109.666667 6
... ... ... ... ...
FreedomsFinalStand.com 260.615385 133.923077 503.777778 13
En-Volve.com 708.882353 197.352941 426.083333 17
DailyNewsPosts.info 748.900000 209.700000 930.000000 20
TrueAmericans.me 398.047619 77.857143 116.833333 21
FedsAlert.com 5666.666667 207.708333 733.600000 24
NewsBreaksHere.com 384.068966 123.103448 66.250000 29
Spinzon.com 609.388889 283.416667 1418.033333 36
USAPoliticsNow.com 440.095238 42.571429 207.200000 42
President45DonaldTrump.com 59.500000 9.217391 13.666667 46
DonaldTrumpPOTUS45.com 6.405063 1.316456 3.490196 79
NeonNettle.com 262.290323 38.129032 205.272727 93
SupremePatriot.com 836.155172 186.017241 510.087379 116
Liberty-Courier.com 41.109375 16.789062 51.500000 128
ANews24.org 410.620155 95.147287 51.311111 129
DailySurge.com 132.217687 27.517007 86.734375 147
ConservativeDailyPost.com 290.761905 85.125000 394.475862 168
AngryPatriotMovement.com 182.476364 23.949091 154.850806 275
Prntly.com 277.353349 51.113164 168.963145 433
TMZWorldNews.com 3307.397089 212.721414 1658.739606 481
USAPoliticsToday.com 910.662028 182.964215 521.643799 503
LiberalPlug.com 3707.660598 388.976593 897.018229 769
WashingtonFeed.com 168.099111 42.341169 98.537227 1574
LibertyAlliance.com 27.660223 6.503222 16.960879 1707
USHerald.com 1292.620227 197.735000 603.190356 4400
Disclose.tv 1794.983759 154.305889 964.005232 7081
FreedomDaily.com 1934.635126 407.649663 991.788549 7567
BeforeItsNews.com 43.076758 8.378301 51.416770 12572
BB4SP.com 157.028226 44.750269 106.180180 13959
ClashDaily.com 445.180088 120.191162 367.379784 38198
MadWorldNews.com 363.949660 95.370830 283.436799 41577

65 rows × 4 columns

In [20]:
fake_domain_seldom = fake_domain[fake_domain['count']<10]
fake_domain_pro = fake_domain[fake_domain['count']>3000]

Add Politician FanPage for Comparison

In [21]:
politician = Path('/home3/usfb/analysis/analysis-fake-news/temp/post-match-domain/politician.csv')
politicians = pd.read_csv(politician)
In [22]:
politics = politicians.groupby('page_name').mean()
politics['count'] = politicians.groupby('page_name').size()
politics= politics[['post_likes','post_comments','post_shares']]
politics
Out[22]:
post_likes post_comments post_shares
page_name
Al Hardwick for Congress in Michigan's 5th District 3.000000 1.250000 3.000000
Andy Biggs 27.000000 4.000000 6.000000
Andy Harris 181.000000 27.000000 14.000000
Andy Whallon for Congress 2.500000 1.000000 0.500000
Ann Wagner 1.000000 1.000000 1.000000
Art Halvorson for Congress 39.000000 18.000000 49.000000
Ben Sasse 474.500000 145.000000 164.500000
Bill Abatecola, R Candidate for US Congress CD3 0.000000 0.000000 NaN
Bill Cassidy 247.750000 49.750000 37.750000
Bill Flores 146.333333 39.666667 18.666667
Bill Ritter 68.000000 50.000000 7.000000
Billy Burkette for Congress 2.000000 0.333333 1.500000
Blaine Luetkemeyer 25.500000 0.500000 3.000000
Bobby Jindal 379.000000 60.000000 39.000000
Brett Geymann for Louisiana 53.000000 3.000000 31.000000
Brian Mast 254.000000 16.400000 63.200000
Buddy Carter 13.000000 3.000000 6.000000
Candice Miller 20.000000 0.000000 4.000000
Cat Ping For Congress 4.909091 3.454545 6.428571
Charles Lingerfelt For U. S. Congress - 2.000000 0.000000 0.000000
Chris Christie 792.428571 105.857143 49.857143
Chris Vance 2.000000 0.000000 1.000000
Chuck Grassley 4.000000 1.000000 1.000000
Claudia Tenney for Congress 221.000000 16.500000 118.666667
Congressman Blake Farenthold 51.727273 14.727273 15.909091
Congressman Chris Stewart 76.000000 10.000000 9.000000
Congressman Daniel Webster 256.000000 40.000000 89.500000
Congressman Darrell E. Issa 821.000000 101.000000 325.666667
Congressman Dave Brat 14.250000 2.750000 6.571429
Congressman Doug Lamborn 45.142857 17.714286 9.714286
... ... ... ...
Senator Rand Paul 1723.500000 91.250000 497.500000
Senator Richard Burr 193.500000 83.000000 67.000000
Senator Richard Shelby 251.000000 21.000000 43.000000
Senator Rob Portman 136.000000 63.000000 6.000000
Senator Ted Cruz 10131.000000 744.500000 2202.500000
Senator Thom Tillis 159.000000 24.000000 24.000000
Senator Todd Young 13.000000 9.000000 1.000000
Sheriff Paul Babeu 114.818182 32.181818 55.272727
Steve Isaacson for Congress 2018 0.000000 0.000000 NaN
Steve King 441.166667 43.583333 59.583333
Steve King for Congress 167.666667 30.333333 67.928571
Steven Palazzo 253.000000 57.000000 21.000000
Sue Googe 10.000000 4.333333 4.666667
Ted Cruz 19128.833333 1036.250000 3495.342857
Ted Cruz Is The Man 566.100775 61.098191 200.191214
Ted Poe 136.333333 41.666667 33.800000
Ted Yoho 370.600000 67.000000 65.200000
Tim Huelskamp for Congress 436.000000 41.000000 75.000000
Todd Young 67.500000 13.750000 11.250000
Tom Cotton 1910.857143 237.142857 573.571429
Tom Marino 77.333333 16.000000 70.666667
Trent Franks 13.000000 3.000000 2.000000
Trey Gowdy News and Support 196.183099 29.309859 160.197183
Troy Arthur Bonar 11.000000 0.000000 NaN
Tulsi Gabbard 469.000000 87.000000 99.000000
U.S. Representative Bradley Byrne 265.600000 33.000000 53.200000
U.S. Representative John Fleming 53.166667 14.111111 35.722222
United States Senator Mike Lee 4932.000000 379.000000 396.000000
Walter Jones 224.555556 37.111111 61.111111
Wendy Long 490.250000 108.000000 224.000000

225 rows × 3 columns

In [23]:
politifact_pro = politifact_with_fake_domain[(politifact_with_fake_domain['domain']=='BB4SP.com')|(politifact_with_fake_domain['domain']=='BeforeItsNews.com')|(politifact_with_fake_domain['domain']=='ClashDaily.com')|(politifact_with_fake_domain['domain']=='Disclose.tv')|(politifact_with_fake_domain['domain']=='FreedomDaily.com')|(politifact_with_fake_domain['domain']=='MadWorldNews.com')|(politifact_with_fake_domain['domain']=='USHerald.com')]
In [24]:
print(fake_domain_seldom['post_likes'].mean())
print(fake_domain_pro['post_likes'].mean())
print(politics['post_likes'].mean())
633.68177008177
861.6391205510283
575.8238362773211
In [25]:
print(fake_domain_seldom['post_comments'].mean())
print(fake_domain_pro['post_comments'].mean())
print(politics['post_comments'].mean())
208.47037037037035
146.91158764378912
59.93571542613603
In [26]:
print(fake_domain_seldom['post_shares'].mean())
print(fake_domain_pro['post_shares'].mean())
print(politics['post_shares'].mean())
672.880808080808
481.0568098908866
135.8483961008781
In [27]:
times = pd.DataFrame()
times = politifact_pro.groupby('post_created_date_CT').mean()
times['count'] = politifact_pro.groupby('post_created_date_CT').size()
times.reset_index(level=0, inplace=True)
times=times[['post_created_date_CT','count']]
times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
plt.rcParams['figure.figsize'] = [10, 5]
mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'])
Out[27]:
[<matplotlib.lines.Line2D at 0x7f7ba50c65c0>]
In [28]:
politifact_seldom = politifact_with_fake_domain[(politifact_with_fake_domain['domain']=='247NewsMedia.com')|(politifact_with_fake_domain['domain']=='AmericanPoliticNews.co	')|(politifact_with_fake_domain['domain']=='BuzzFeedUSA.com	')|(politifact_with_fake_domain['domain']=='CivicTribune.com')|(politifact_with_fake_domain['domain']=='ConservativeSpirit.com')|(politifact_with_fake_domain['domain']=='DemocraticMoms.com')|(politifact_with_fake_domain['domain']=='FederalistTribune.com')|(politifact_with_fake_domain['domain']=='GiverLiberty01.com')|(politifact_with_fake_domain['domain']=='GummyPost.com')|(politifact_with_fake_domain['domain']=='LastDeplorables.com')|(politifact_with_fake_domain['domain']=='NewPoliticsToday.com')|(politifact_with_fake_domain['domain']=='NewsExaminer.net')|(politifact_with_fake_domain['domain']=='NewsMagazine.com')|(politifact_with_fake_domain['domain']=='NoteAllowedTo.com')|(politifact_with_fake_domain['domain']=='OnePoliticalPlaza.com')|(politifact_with_fake_domain['domain']=='PoliticsUSANews.com')|
                                                (politifact_with_fake_domain['domain']=='ReadConservatives.news')|(politifact_with_fake_domain['domain']=='RedCountry.us')|(politifact_with_fake_domain['domain']=='ReligionMind.com')|(politifact_with_fake_domain['domain']=='TDTAlliance.com	')|(politifact_with_fake_domain['domain']=='The-Insider.co')|(politifact_with_fake_domain['domain']=='TheTrumpMedia.com')|(politifact_with_fake_domain['domain']=='USADailyInfo.com')|(politifact_with_fake_domain['domain']=='USADailyTime.com')|
                                                (politifact_with_fake_domain['domain']=='USANewsHome.com')|(politifact_with_fake_domain['domain']=='USAPolitics24hrs.com')|(politifact_with_fake_domain['domain']=='USASnich.com')|(politifact_with_fake_domain['domain']=='USHealthyAdvisor.com')|
                                                (politifact_with_fake_domain['domain']=='USInfoNews.com')|(politifact_with_fake_domain['domain']=='USPOLN.com')|(politifact_with_fake_domain['domain']=='USPostman.com')|(politifact_with_fake_domain['domain']=='UndergroundNewsReport.com')|(politifact_with_fake_domain['domain']=='VoxTribune.com')]
In [29]:
times = pd.DataFrame()
times = politifact_seldom.groupby('post_created_date_CT').mean()
times['count'] = politifact_seldom.groupby('post_created_date_CT').size()
times.reset_index(level=0, inplace=True)
times=times[['post_created_date_CT','count']]
times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
plt.rcParams['figure.figsize'] = [10, 5]
mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'])
Out[29]:
[<matplotlib.lines.Line2D at 0x7f7ba4ffe588>]
In [30]:
post_sort_by_created_time = politifact_with_fake_domain.sort_values(['page_name','post_created_date_CT'])

domain page relation

In [31]:
page_domain = politifact_with_fake_domain.groupby(['page_name','domain']).size()
page_domain = page_domain.reset_index()
page_domain
Out[31]:
page_name domain 0
0 1 Million Strong For Hillary Clinton in 2016 Prntly.com 3
1 1 Million Strong For Hillary Clinton in 2016 Spinzon.com 1
2 100 Percent FED Up ClashDaily.com 158
3 100 Percent FED Up FreedomDaily.com 18
4 100 Percent FED Up USHerald.com 9
5 Abolish The IRS DailySurge.com 6
6 Abolish The IRS USHerald.com 93
7 Adryenn Ashley LibertyAlliance.com 1
8 African-American Conservatives DailySurge.com 1
9 African-American Conservatives USHerald.com 1
10 Allen West Republic BB4SP.com 2142
11 Allen West Republic BeforeItsNews.com 1
12 Allen West Republic ClashDaily.com 1457
13 Allen West Republic LibertyAlliance.com 6
14 Allen West Republic USHerald.com 300
15 America Elects a Leader president 247NewsMedia.com 1
16 America Elects a Leader president BB4SP.com 2
17 America Elects a Leader president BeforeItsNews.com 1
18 America Elects a Leader president ClashDaily.com 1
19 America Elects a Leader president ConservativeDailyPost.com 4
20 America Elects a Leader president DailySurge.com 1
21 America Elects a Leader president FreedomDaily.com 3
22 America Elects a Leader president MadWorldNews.com 1
23 America Elects a Leader president NewsBreaksHere.com 1
24 America Elects a Leader president TheTrumpMedia.com 1
25 America Elects a Leader president USAPoliticsToday.com 1
26 America Elects a Leader president USHerald.com 3
27 America Elects a Leader president UndergroundNewsReport.com 1
28 America Elects a Leader president VoxTribune.com 2
29 America Needs a Truthful president AngryPatriotMovement.com 2
... ... ... ...
715 The Witty Liberal DailySurge.com 2
716 The Witty Liberal En-Volve.com 1
717 The Witty Liberal USAPoliticsNow.com 3
718 The Witty Liberal UniversePolitics.com 2
719 The voice of the people BeforeItsNews.com 1
720 The voice of the people ClashDaily.com 1
721 The voice of the people Disclose.tv 1
722 The voice of the people MadWorldNews.com 1
723 Trina FedsAlert.com 13
724 Trina TMZWorldNews.com 338
725 Wake Up News NeonNettle.com 3
726 Wake Up News USAPoliticsToday.com 2
727 Wayne Allyn Root AngryPatriotMovement.com 1
728 Wayne Allyn Root ClashDaily.com 2
729 Wayne Allyn Root ConservativeDailyPost.com 2
730 Wayne Allyn Root DailySurge.com 1
731 Wayne Allyn Root FreedomDaily.com 1
732 Wayne Allyn Root MadWorldNews.com 4
733 Wayne Allyn Root Prntly.com 1
734 Wayne Allyn Root Spinzon.com 1
735 Wayne Allyn Root USHerald.com 1
736 Wayne Dupree Show LibertyAlliance.com 1
737 Wayne Dupree Show USHerald.com 2
738 WikiLeaks Updates AngryPatriotMovement.com 1
739 WikiLeaks Updates BeforeItsNews.com 1
740 WikiLeaks Updates USAPoliticsToday.com 1
741 WikiLeaks Updates USHerald.com 1
742 WikiLeaksParty BeforeItsNews.com 1
743 Wonkette ConservativeDailyPost.com 1
744 philly.com The-Insider.co 4

745 rows × 3 columns

pages with the same name as domain

In [32]:
similar_or_the_same_name= ['Barracuda Brigade',
                           'ClashDaily.com with Doug Giles',
                           'Mad World News',
                           'Breitbart - One Voice Silenced, Millions Awakened',
                           'Disclose.tv',
                           'Freedom Daily',
                           'Liberal Daily']
In [33]:
first_post_create_time = pd.DataFrame()
for i in similar_or_the_same_name:
    first_created = post_sort_by_created_time[post_sort_by_created_time['page_name']==i].head(1)
    first_post_create_time = pd.concat([first_post_create_time,first_created])
first_post_create_time = first_post_create_time[['page_name','post_created_date_CT']]
first_post_create_time['post_created_date_CT'] = first_post_create_time['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
first_post_create_time
Out[33]:
page_name post_created_date_CT
97321 Barracuda Brigade 2015-03-15
64262 ClashDaily.com with Doug Giles 2014-12-31
28108 Mad World News 2014-12-31
48013 Breitbart - One Voice Silenced, Millions Awakened 2015-05-03
22874 Disclose.tv 2015-01-01
8856 Freedom Daily 2016-03-14
6954 Liberal Daily 2017-01-02
In [34]:
page_domain_same = politifact_with_fake_domain[(politifact_with_fake_domain['page_name'] == 'Barracuda Brigade') | (politifact_with_fake_domain['page_name'] == 'ClashDaily.com with Doug Giles') |
                         (politifact_with_fake_domain['page_name'] == 'Mad World News') |(politifact_with_fake_domain['page_name'] == 'Breitbart - One Voice Silenced, Millions Awakened') |
                         (politifact_with_fake_domain['page_name'] == 'Disclose.tv') |(politifact_with_fake_domain['page_name'] == 'Freedom Daily') |(politifact_with_fake_domain['page_name'] == 'Liberal Daily')]
In [35]:
plt.rcParams['figure.figsize'] = [60, 50]
times = pd.DataFrame()
for i in similar_or_the_same_name:
    times = page_domain_same[page_domain_same['page_name']==i].groupby('post_created_date_CT').mean()
    times['count'] = page_domain_same[page_domain_same['page_name']==i].groupby('post_created_date_CT').size()
    times.reset_index(level=0, inplace=True)
    times=times[['post_created_date_CT','count']]
    times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
    mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'], color = np.random.rand(3,),ls = 'solid')

pages with different name as domain

In [36]:
page_domain_different = page_domain_same[(page_domain_same['domain']!='BB4SP.com')|(page_domain_same['domain']!='Disclose.tv')|
                                        (page_domain_same['domain']!='FreedomDaily.com')|(page_domain_same['domain']!='LiberalPlug.com')|
                                        (page_domain_same['domain']!='MadWorldNews.com')]
page_domain_different = page_domain_different[(page_domain_different['page_name']=='ClashDaily.com with Doug Giles')&
                                             (page_domain_different['domain']!='ClashDaily.com')]
page_domain_different
Out[36]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count domain category type
82 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1007442819372496 link BREAKING: Judge Initiates Investigation Over O... Obama has lied to the American people and he n... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/breaking-judge-initiates-i... “The Wheels of Justice Grind Slow, But They Gr... ... 2016-06-28T14:35:01Z 2016-07-02T10:24:48Z 2016-06-28 2016-07-02 2016-06-28T19:35:01Z 2016-07-02T15:24:48Z 152602.0 USHerald.com News/Media Website media
101 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1049407408509370 link 'The View' Is On The Chopping Block To Be Canc... It's about time this liberal trash was yanked ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/the-view-is-about-to-be-ca... “Please” say it isn’t so! Can it be true? You ... ... 2016-08-21T12:35:01Z 2016-08-23T04:40:30Z 2016-08-21 2016-08-23 2016-08-21T17:35:01Z 2016-08-23T09:40:30Z 432956.0 USHerald.com News/Media Website media
126 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1003878156395629 link Military Generals Take Steps To Arrest Obama O... Military Generals Take Steps To Arrest Obama O... usherald.com https://fbexternal-a.akamaihd.net/safe_image.p... http://usherald.com/military-generals-move-to-... There’s absolutely no doubt that President Oba... ... 2016-06-23T15:35:01Z 2016-06-25T04:35:49Z 2016-06-23 2016-06-25 2016-06-23T20:35:01Z 2016-06-25T09:35:49Z 585611.0 USHerald.com News/Media Website media
173 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1021063921343719 link INSPIRING: Wounded Vet To Open Business Whose ... 'God Kept Me Alive for a Reason'\r\n\r\nCan we... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/inspiring-wounded-war-vete... This incredible soldier continues to give and ... ... 2016-07-17T13:35:01Z 2016-07-19T23:50:17Z 2016-07-17 2016-07-19 2016-07-17T18:35:01Z 2016-07-20T04:50:17Z 525734.0 USHerald.com News/Media Website media
209 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1139574249492685 link VIDEO: Obama Trying To SILENCE Judge Pirro Aft... Obama wants to SILENCE Judge Pirro after what ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/video-obama-trying-silence... If you’re a fan of Jeanine Pirro, the popular ... ... 2016-11-24T14:35:02Z 2016-11-25T23:22:57Z 2016-11-24 2016-11-25 2016-11-24T20:35:02Z 2016-11-26T05:22:57Z 800737.0 USHerald.com News/Media Website media
220 228702593913193 ClashDaily.com with Doug Giles 228702593913193_953488141434631 link McDonalds, Pizza Hut And KFC Refuse Muslim Dem... Muslims are furious but it's too late. They ar... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/mcdonalds-pizza-hut-kfc-re... "Hold the pickle, hold the lettuce special ord... ... 2016-04-16T14:35:00Z 2016-04-17T11:45:53Z 2016-04-16 2016-04-17 2016-04-16T19:35:00Z 2016-04-17T16:45:53Z 184917.0 USHerald.com News/Media Website media
222 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1032108510239260 link VIDEO: Obama Trying To SILENCE Judge Pirro Aft... Obama wants to SILENCE Judge Pirro after what ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/video-obama-trying-silence... If you’re a fan of Jeanine Pirro, the popular ... ... 2016-08-01T00:35:01Z 2016-08-02T22:18:56Z 2016-08-01 2016-08-02 2016-08-01T05:35:01Z 2016-08-03T03:18:56Z 476505.0 USHerald.com News/Media Website media
368 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1002509363199175 link BREAKING VIDEO: Ohio Muslims Launch Civil War ... BREAKING: Muslims raging after Ohio man rips Q... usherald.com https://fbexternal-a.akamaihd.net/safe_image.p... http://usherald.com/breaking-video-ohio-muslim... A Ohio man has created a huge controversy by s... ... 2016-06-21T17:35:01Z 2016-06-23T11:08:21Z 2016-06-21 2016-06-23 2016-06-21T22:35:01Z 2016-06-23T16:08:21Z 617184.0 USHerald.com News/Media Website media
418 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1026511237465654 link Michelle Obama Gets Served... But This Time It... Michelle Obama Gets Served… But This Time It’s... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/michelle-obama-gets-served... By now it's a well-known fact that Barack and ... ... 2016-07-24T14:35:01Z 2016-07-26T10:26:08Z 2016-07-24 2016-07-26 2016-07-24T19:35:01Z 2016-07-26T15:26:08Z 622369.0 USHerald.com News/Media Website media
462 228702593913193 ClashDaily.com with Doug Giles 228702593913193_940047842778661 link Top Army Chief of Staff General Has Had It Wit... Top Army Chief of Staff General Has Had It Wit... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/top-army-chief-of-staff-ge... With the growing threat of terrorism around th... ... 2016-03-29T14:35:00Z 2016-03-31T04:08:21Z 2016-03-29 2016-03-31 2016-03-29T19:35:00Z 2016-03-31T09:08:21Z 273505.0 USHerald.com News/Media Website media
467 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1134938123289631 link MASSIVE Food Stamp Fraud Operation Taken Down ... These lowlifes have stolen an UNBELIEVABLE amo... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/operation-stampede-busts-m... And liberals are constantly fighting against w... ... 2016-11-20T14:35:01Z 2016-11-21T22:34:08Z 2016-11-20 2016-11-21 2016-11-20T20:35:01Z 2016-11-22T04:34:08Z 798996.0 USHerald.com News/Media Website media
484 228702593913193 ClashDaily.com with Doug Giles 228702593913193_993081014142010 link What France Has Found In Mosque Raids Deeply D... BREAKING: France is raiding Mosques and the sh... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/france-found-mosque-raids-... Once again Donald Trump has created a firestor... ... 2016-06-07T14:35:01Z 2016-06-11T20:08:27Z 2016-06-07 2016-06-11 2016-06-07T19:35:01Z 2016-06-12T01:08:27Z 152602.0 USHerald.com News/Media Website media
493 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1207085199408256 link 'Bikers For Trump' Set to Be The LARGEST Pro-T... Can we get 5,000 LIKES & SHARES in support of ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/bikers-trump-set-largest-p... As the nation prepares for the uniquely Americ... ... 2017-01-15T12:36:05Z 2017-01-18T08:05:32Z 2017-01-15 2017-01-18 2017-01-15T18:36:05Z 2017-01-18T14:05:32Z 161374.0 USHerald.com News/Media Website media
542 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1006721516111293 link London Islamic Mayor's Warning To Trump: Let M... London's new Muslim mayor has issued a dire wa... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/muslim-mayor-london-warns-... When we as Americans think of terrorist enclav... ... 2016-06-27T14:35:01Z 2016-07-08T18:11:44Z 2016-06-27 2016-07-08 2016-06-27T19:35:01Z 2016-07-08T23:11:44Z 152602.0 USHerald.com News/Media Website media
546 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1000315410085237 link VIDEO: Muslim Police Chief Shows This Act Of C... VIDEO: Muslim Police Chief Shows This Act Of C... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/video-muslim-police-chief-... Anyone who has ever served in uniform knows to... ... 2016-06-18T14:35:01Z 2017-02-05T15:09:09Z 2016-06-18 2017-02-05 2016-06-18T19:35:01Z 2017-02-05T21:09:09Z 152602.0 USHerald.com News/Media Website media
564 228702593913193 ClashDaily.com with Doug Giles 228702593913193_945213018928810 link This Southern City Just Voted to Fly The Confe... This Southern City Just Voted to Fly The Confe... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.usherald.com/this-southern-city-jus... Every flag ever waved or raised in conflict ha... ... 2016-04-04T14:35:01Z 2016-04-06T07:56:21Z 2016-04-04 2016-04-06 2016-04-04T19:35:01Z 2016-04-06T12:56:21Z 215423.0 USHerald.com News/Media Website media
614 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1015068038609974 link Mayor SETS Syrian Refugees STRAIGHT: 'We Don’t... Mayor SETS Syrian Refugees STRAIGHT: 'We Don’t... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/29DwVWv America needs to get with the program when it ... ... 2016-07-09T14:35:01Z 2016-07-11T09:27:46Z 2016-07-09 2016-07-11 2016-07-09T19:35:01Z 2016-07-11T14:27:46Z 815755.0 USHerald.com News/Media Website media
731 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1074630562653721 link Obama Facing Up To 10 Years To Life In Prison ... Obama Facing Up To 10 Years To Life In Prison ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/obama-facing-10-years-in-p... Do you remember the name Bowe Bergdahl? If not... ... 2016-09-18T14:35:01Z 2016-09-20T08:49:39Z 2016-09-18 2016-09-20 2016-09-18T19:35:01Z 2016-09-20T13:49:39Z 273355.0 USHerald.com News/Media Website media
770 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1231551473628295 link BREAKING: White House Is DONE With CNN, Just C... CNN's continual attack on our President just b... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/breaking-white-house-done-... Most rational and reasonable individuals expec... ... 2017-02-03T12:36:00Z 2017-02-06T20:33:24Z 2017-02-03 2017-02-06 2017-02-03T18:36:00Z 2017-02-07T02:33:24Z 160456.0 USHerald.com News/Media Website media
851 228702593913193 ClashDaily.com with Doug Giles 228702593913193_989251274524984 link This U.S. General Just Ripped Wide Open Obama'... This U.S. General Just Ripped Wide Open Obama'... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/this-u-s-general-just-ripp... It is hard to imagine after witnessing first h... ... 2016-06-01T15:35:01Z 2016-06-03T10:33:32Z 2016-06-01 2016-06-03 2016-06-01T20:35:01Z 2016-06-03T15:33:32Z 152602.0 USHerald.com News/Media Website media
852 228702593913193 ClashDaily.com with Doug Giles 228702593913193_884610791655700 link This Comedian Promises To Move To Africa If Do... This Comedian Vows To Move To Africa If Donald... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/WxHW9 Comedian Eddie Griffin is putting his foot dow... ... 2016-01-02T15:05:10Z 2016-01-04T03:38:03Z 2016-01-02 2016-01-04 2016-01-02T21:05:10Z 2016-01-04T09:38:03Z 166931.0 USHerald.com News/Media Website media
861 228702593913193 ClashDaily.com with Doug Giles 228702593913193_879999368783509 link McDonalds, Pizza Hut And KFC Refuse Muslim Dem... Muslims are furious but it's too late. They ar... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/mcdonalds-pizza-hut-kfc-re... "Hold the pickle, hold the lettuce special ord... ... 2015-12-25T15:18:07Z 2015-12-27T12:01:17Z 2015-12-25 2015-12-27 2015-12-25T21:18:07Z 2015-12-27T18:01:17Z 201709.0 USHerald.com News/Media Website media
936 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1138248099625300 link 63-Year-Old Vet Sniper Returns From Retirement... So much for sitting back and taking it easy. T... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/63-year-old-vet-sniper-com... No sitting at home collecting Social Security ... ... 2016-11-23T14:35:01Z 2016-11-28T02:36:37Z 2016-11-23 2016-11-28 2016-11-23T20:35:01Z 2016-11-28T08:36:37Z 160456.0 USHerald.com News/Media Website media
949 228702593913193 ClashDaily.com with Doug Giles 228702593913193_954815981301847 link COINCIDENCE? Ford Cancels U.S. Plant Move To M... COINCIDENCE? Ford Cancels U.S. Plant Move To M... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/coincidence-or-trump-effec... Can it be that “The Donald” is already affecti... ... 2016-04-18T14:35:01Z 2016-04-20T11:41:08Z 2016-04-18 2016-04-20 2016-04-18T19:35:01Z 2016-04-20T16:41:08Z 214366.0 USHerald.com News/Media Website media
1010 228702593913193 ClashDaily.com with Doug Giles 228702593913193_930830750367037 link Sam's Club CEO Is Paying Dearly For Anti-White... Sam's Club CEO made some serious anit-white ra... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/sams-club-ceo-paying-dearl... Why would any CEO of a major international cha... ... 2016-03-19T15:35:00Z 2016-03-21T12:12:05Z 2016-03-19 2016-03-21 2016-03-19T20:35:00Z 2016-03-21T17:12:05Z 113790.0 USHerald.com News/Media Website media
1169 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1223974397719336 link SEE YA! Liberals OUTRAGED After Trump Orders 9... Donald Trump just boldly gave 92 Muslims the b... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/see-ya-liberals-outraged-t... Finally, a President who actually makes good o... ... 2017-01-28T12:36:00Z 2017-01-31T16:00:57Z 2017-01-28 2017-01-31 2017-01-28T18:36:00Z 2017-01-31T22:00:57Z 161374.0 USHerald.com News/Media Website media
1189 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1033257173457727 link Tom Selleck Is A REAL DEAL PATRIOT... Watch Hi... Obama and Black Lives Matter want Tom Selleck'... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/liberals-outraged-after-to... Tom Selleck has never backed down when it come... ... 2016-08-02T13:35:01Z 2016-08-04T12:34:38Z 2016-08-02 2016-08-04 2016-08-02T18:35:01Z 2016-08-04T17:34:38Z 400774.0 USHerald.com News/Media Website media
1219 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1145614215555355 link Rapper Calls For Gang Rape Of Palin, Sarah's S... BRAVO! This rapper thug is backtracking as fas... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/rapper-calls-gang-rape-pal... This rapper is backtracking as fast as she can... ... 2016-11-28T14:35:01Z 2016-11-30T19:46:55Z 2016-11-28 2016-11-30 2016-11-28T20:35:01Z 2016-12-01T01:46:55Z 160456.0 USHerald.com News/Media Website media
1299 228702593913193 ClashDaily.com with Doug Giles 228702593913193_919558821494230 link Whoopi Goldberg Is Moving Out Of U.S. For THIS... It's past time she get OUT! Who wants her here... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/whoopi-goldberg-moving-u-s... If it were only true! However knowing the prog... ... 2016-03-02T15:35:00Z 2016-03-04T10:09:18Z 2016-03-02 2016-03-04 2016-03-02T21:35:00Z 2016-03-04T16:09:18Z 197611.0 USHerald.com News/Media Website media
1336 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1025749820875129 link BREAKING: Government Of Kenya Has Released Oba... BREAKING: Government Of Kenya Has Released Oba... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/kenya-releases-obama-birth... "There is something on that birth certificate ... ... 2016-07-23T14:35:01Z 2016-07-25T13:40:12Z 2016-07-23 2016-07-25 2016-07-23T19:35:01Z 2016-07-25T18:40:12Z 626984.0 USHerald.com News/Media Website media
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
76382 228702593913193 ClashDaily.com with Doug Giles 228702593913193_898923073557805 link Man Scares His Wife By Yelling At Her In The K... Well now, that's one way to make a point!\n\nP... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/XEqUY Heh, didn't see that coming. Please share if i... ... 2016-01-28T14:03:21Z 2016-01-28T21:16:43Z 2016-01-28 2016-01-28 2016-01-28T20:03:21Z 2016-01-29T03:16:43Z 159876.0 USHerald.com News/Media Website media
77232 228702593913193 ClashDaily.com with Doug Giles 228702593913193_906053656178080 link Game Warden Wants to Arrest The Fisherman's Wi... I think the warden knew he wasn't going to win... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/YaBW8 Source ... 2016-02-10T11:05:33Z 2016-02-10T14:37:04Z 2016-02-10 2016-02-10 2016-02-10T17:05:33Z 2016-02-10T20:37:04Z 168470.0 USHerald.com News/Media Website media
78007 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1037791859670925 link Burka-Clad Muslim Woman Comes Out Of Woods Wit... These girls thought they could enjoy a beautif... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/burka-clad-muslim-woman-co... Dami Arno and her daughter Brittany Arno were ... ... 2016-08-08T14:35:01Z 2016-08-09T19:36:26Z 2016-08-08 2016-08-09 2016-08-08T19:35:01Z 2016-08-10T00:36:26Z 0.0 USHerald.com News/Media Website media
78093 228702593913193 ClashDaily.com with Doug Giles 228702593913193_968750436575068 link Man Gets In Horrible Car Accident And Sends Wi... This poor fella was caught off guard when his ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/man-gets-horrible-car-acci... If you got a good laugh from this one please '... ... 2016-05-02T14:35:00Z 2016-05-02T14:35:00Z 2016-05-02 2016-05-02 2016-05-02T19:35:00Z 2016-05-02T19:35:00Z 258013.0 USHerald.com News/Media Website media
79085 228702593913193 ClashDaily.com with Doug Giles 228702593913193_918275768289202 link THIS Is How Muslim Mother "Fixes" Rape Of 2-Ye... THIS Is How Muslim Mother "Fixes" Rape Of 2-Ye... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/grandpa-rapes-2-year-old-g... Even in a religious culture that advocates the... ... 2016-02-29T13:35:01Z 2016-03-01T04:35:44Z 2016-02-29 2016-03-01 2016-02-29T19:35:01Z 2016-03-01T10:35:44Z 211392.0 USHerald.com News/Media Website media
80610 228702593913193 ClashDaily.com with Doug Giles 228702593913193_993057980810980 link WATCH: This Viral Video is Out to Prove That O... WATCH: This Viral Video is Out to Prove That O... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/watch-rockin-viral-video-o... Now this might not be very political, but we t... ... 2016-06-07T13:35:01Z 2016-06-07T14:49:17Z 2016-06-07 2016-06-07 2016-06-07T18:35:01Z 2016-06-07T19:49:17Z 152602.0 USHerald.com News/Media Website media
81892 228702593913193 ClashDaily.com with Doug Giles 228702593913193_890577691059010 link Mother Asks Her Young Son What Is Going On In ... This exchange between a patient mother and her... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/X0SqV This kid is seriously cute. If you got a kick ... ... 2016-01-13T12:01:56Z 2016-01-13T13:21:18Z 2016-01-13 2016-01-13 2016-01-13T18:01:56Z 2016-01-13T19:21:18Z 184330.0 USHerald.com News/Media Website media
82333 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1041726389277472 link Burka-Clad Muslim Woman Comes Out Of Woods Wit... Dami Arno and her daughter Brittany Arno were ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/burka-clad-muslim-woman-co... Dami Arno and her daughter Brittany Arno were ... ... 2016-08-12T13:02:01Z 2016-08-13T18:12:27Z 2016-08-12 2016-08-13 2016-08-12T18:02:01Z 2016-08-13T23:12:27Z 407070.0 USHerald.com News/Media Website media
83006 228702593913193 ClashDaily.com with Doug Giles 228702593913193_883997951716984 link Pastor Goes To Elderly Woman's Home To Check O... We totally did not see this one coming. Oh boy... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/WwdOF This pastor gets a LOT than he bargained for w... ... 2016-01-01T12:05:10Z 2016-01-01T13:13:33Z 2016-01-01 2016-01-01 2016-01-01T18:05:10Z 2016-01-01T19:13:33Z 191210.0 USHerald.com News/Media Website media
83581 228702593913193 ClashDaily.com with Doug Giles 228702593913193_953487748101337 link Teacher Asked Her Students About Hillary Clint... Smart Kids!\n\nIf you laughed, share it. usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/teacher-asked-her-students... Smart kid. We love this one. Please take a mom... ... 2016-04-16T12:35:01Z 2016-04-17T03:24:26Z 2016-04-16 2016-04-17 2016-04-16T17:35:01Z 2016-04-17T08:24:26Z 184917.0 USHerald.com News/Media Website media
83901 228702593913193 ClashDaily.com with Doug Giles 228702593913193_930830233700422 link FULL LIST Of U.S. Cities With Addresses Where ... Obama has setup locations all over the country... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/see-full-list-u-s-cities-f... The carnage that took place in Paris on Friday... ... 2016-03-19T14:35:01Z 2016-03-20T23:15:33Z 2016-03-19 2016-03-20 2016-03-19T19:35:01Z 2016-03-21T04:15:33Z 113790.0 USHerald.com News/Media Website media
84436 228702593913193 ClashDaily.com with Doug Giles 228702593913193_910273689089410 link This Hilarious Dear Abby Letter Just Might Cha... This woman got a SERIOUSLY surprising answer w... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/dear-abby-joke-letter-pres... This Dear Abby letter is hilarious! Please enj... ... 2016-02-17T12:32:53Z 2016-02-17T14:30:56Z 2016-02-17 2016-02-17 2016-02-17T18:32:53Z 2016-02-17T20:30:56Z 221310.0 USHerald.com News/Media Website media
85221 228702593913193 ClashDaily.com with Doug Giles 228702593913193_964834256966686 link 'Typical Male' Makes Typical Decision When Dec... Don't worry ladies, not all guys are this bad.... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/typical-male-makes-typical... If you smiled, share it. Source ... 2016-04-26T18:32:35Z 2016-04-27T07:39:46Z 2016-04-26 2016-04-27 2016-04-26T23:32:35Z 2016-04-27T12:39:46Z 268434.0 USHerald.com News/Media Website media
87051 228702593913193 ClashDaily.com with Doug Giles 228702593913193_940047729445339 link PICS: Ranger Finds Hidden Cabin In Forest, Wha... PICS: Ranger Finds Hidden Cabin In Forest, Wha... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/pics-forest-ranger-spots-h... Everyone loves a good mystery. Imagine stumbli... ... 2016-03-29T13:35:00Z 2016-03-30T18:10:51Z 2016-03-29 2016-03-30 2016-03-29T18:35:00Z 2016-03-30T23:10:51Z 273505.0 USHerald.com News/Media Website media
87473 228702593913193 ClashDaily.com with Doug Giles 228702593913193_901765453273567 link Pastor Gets A Big Surprise When He Checks On A... This is why you always ask first.\n\nHit 'Like... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/XRHdG this with someone who would laugh. Source ... 2016-02-02T15:05:12Z 2016-02-02T17:58:15Z 2016-02-02 2016-02-02 2016-02-02T21:05:12Z 2016-02-02T23:58:15Z 183550.0 USHerald.com News/Media Website media
90160 228702593913193 ClashDaily.com with Doug Giles 228702593913193_900129533437159 link FUNNY: Little Johnny Uses Obama's Method To Ge... You got to hand it to 'Little Johnny', he must... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/XJt00 Well, that rascal 'Little Johnny" seems to hav... ... 2016-01-30T15:05:10Z 2016-01-31T00:07:34Z 2016-01-30 2016-01-31 2016-01-30T21:05:10Z 2016-01-31T06:07:34Z 144249.0 USHerald.com News/Media Website media
90174 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1294414227342019 link Liberal Mother Gets “Culturally Bullied” Into ... This progressive mother who WAS ALL ABOUT tran... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/liberal-mother-gets-cultur... It’s often been acknowledged that the surest w... ... 2017-03-28T12:35:00Z 2017-03-28T21:43:37Z 2017-03-28 2017-03-28 2017-03-28T17:35:00Z 2017-03-29T02:43:37Z 160456.0 USHerald.com News/Media Website media
90436 228702593913193 ClashDaily.com with Doug Giles 228702593913193_975479522568826 link Muslims Say Sex Slaves Aren't Enough - What Th... What radical muslims are allowed to do to thei... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/muslims-say-sex-slaves-are... It better never fly here. For those in areas t... ... 2016-05-12T12:35:00Z 2016-05-12T13:27:13Z 2016-05-12 2016-05-12 2016-05-12T17:35:00Z 2016-05-12T18:27:13Z 259327.0 USHerald.com News/Media Website media
92272 228702593913193 ClashDaily.com with Doug Giles 228702593913193_886709494779163 link Two Young Boys Go Into The Pharmacy And Ask Fo... This pharmacist did not expect these two young... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/WIfbr We how this je plays out. If you enjoyed the i... ... 2016-01-06T12:05:10Z 2016-01-06T14:52:12Z 2016-01-06 2016-01-06 2016-01-06T18:05:10Z 2016-01-06T20:52:12Z 162806.0 USHerald.com News/Media Website media
92666 228702593913193 ClashDaily.com with Doug Giles 228702593913193_993017107481734 link Muslim Couple Who Falsely Accused Man Of Hate ... A Muslim Imam and his wife said that this whit... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/muslim-couple-falsely-accu... This Imam and his wife got BUSTED HARD in thei... ... 2016-06-07T12:35:01Z 2016-06-07T12:42:04Z 2016-06-07 2016-06-07 2016-06-07T17:35:01Z 2016-06-07T17:42:04Z 314186.0 USHerald.com News/Media Website media
94670 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1080886332028144 link BREAKING: Armed Black Panthers Are Now Terrori... BREAKING: Armed Black Panthers Are Now Terrori... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/breaking-armed-black-panth... “We accept all oppressed people of color with ... ... 2016-09-25T12:35:01Z 2016-09-25T13:40:36Z 2016-09-25 2016-09-25 2016-09-25T17:35:01Z 2016-09-25T18:40:36Z 253950.0 USHerald.com News/Media Website media
95614 228702593913193 ClashDaily.com with Doug Giles 228702593913193_896682680448511 link Employee Uses This Trick to Score a Raise That... Well you got to admit, he pulled one over on t... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/Xsv9y Pretty clever. I wish someone had told me abou... ... 2016-01-24T11:05:11Z 2016-01-24T11:27:01Z 2016-01-24 2016-01-24 2016-01-24T17:05:11Z 2016-01-24T17:27:01Z 171856.0 USHerald.com News/Media Website media
95962 228702593913193 ClashDaily.com with Doug Giles 228702593913193_994238814026230 link Little Boy Asks His Dad "What is Politics?", Y... This kid is pretty sharp.\n\nShare with someon... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/little-boy-asks-his-dad-wh... Sounds about right. Share with someone today. ... ... 2016-06-09T14:35:00Z 2016-06-09T15:06:26Z 2016-06-09 2016-06-09 2016-06-09T19:35:00Z 2016-06-09T20:06:26Z 152602.0 USHerald.com News/Media Website media
99957 228702593913193 ClashDaily.com with Doug Giles 228702593913193_895698323880280 link Man Tries to Report Burglary, But Cops Say The... Man Tries to Report a Burglary, But Cops Say T... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/XpLNj Pretty clever, eh? Please share with a friend.... ... 2016-01-22T13:05:08Z 2016-01-22T13:09:39Z 2016-01-22 2016-01-22 2016-01-22T19:05:08Z 2016-01-22T19:09:39Z 159242.0 USHerald.com News/Media Website media
103304 228702593913193 ClashDaily.com with Doug Giles 228702593913193_889528744497238 link Rebellious Girl Gets An Attitude With An Older... HAHA, this young and rebellious young lady mig... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/WUAeL HAHA, this young and rebellious young lady mig... ... 2016-01-11T13:05:14Z 2016-01-11T19:49:59Z 2016-01-11 2016-01-11 2016-01-11T19:05:14Z 2016-01-12T01:49:59Z 184330.0 USHerald.com News/Media Website media
103781 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1238686076248168 link US Herald WATCH: Casey Anthony Reemerges At Trump Protes... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/watch-remember-casey-antho... Real News Online ... 2017-02-09T13:35:01Z 2017-02-10T18:24:01Z 2017-02-09 2017-02-10 2017-02-09T19:35:01Z 2017-02-11T00:24:01Z 160456.0 USHerald.com News/Media Website media
103788 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1075652859218158 link Pussification: The Effeminization of the Ameri... Femme fatale and blogger, Alicia Powe, just go... dailysurge.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/WWvd304mLC2 If you're a pussy, this book will shred what's... ... 2016-09-19T18:44:58Z 2016-09-19T21:04:52Z 2016-09-19 2016-09-19 2016-09-19T23:44:58Z 2016-09-20T02:04:52Z 236948.0 DailySurge.com News/Media Website media
108574 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1080936745356436 link Top Army Chief of Staff General Has Had It Wit... Top Army Chief of Staff General Has Had It Wit... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/top-army-chief-of-staff-ge... With the growing threat of terrorism around th... ... 2016-09-25T13:35:01Z 2016-09-25T13:35:01Z 2016-09-25 2016-09-25 2016-09-25T18:35:01Z 2016-09-25T18:35:01Z 253950.0 USHerald.com News/Media Website media
109164 228702593913193 ClashDaily.com with Doug Giles 228702593913193_1031128753670569 link US Herald Well folks, Just because you take your shirt o... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/topless-protesters-demandi... Real News Online ... 2016-07-30T15:35:19Z 2016-07-30T19:58:42Z 2016-07-30 2016-07-30 2016-07-30T20:35:19Z 2016-07-31T00:58:42Z 516607.0 USHerald.com News/Media Website media
129671 228702593913193 ClashDaily.com with Doug Giles 228702593913193_989907711126007 link US Herald A classic joke about the way government works.... usherald.com https://external.xx.fbcdn.net/safe_image.php?w... http://usherald.com/three-contractors-are-bidd... Real News Online ... 2016-06-02T15:35:02Z 2016-06-02T15:35:02Z 2016-06-02 2016-06-02 2016-06-02T20:35:02Z 2016-06-02T20:35:02Z 152602.0 USHerald.com News/Media Website media

784 rows × 24 columns

In [37]:
times = pd.DataFrame()
times = page_domain_different.groupby('post_created_date_CT').mean()
times['count'] = page_domain_different.groupby('post_created_date_CT').size()
times.reset_index(level=0, inplace=True)
times=times[['post_created_date_CT','count']]
times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
plt.rcParams['figure.figsize'] = [25, 12]
mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'],'b-')
Out[37]:
[<matplotlib.lines.Line2D at 0x7f7ba4f93a20>]

pages that posts mainly from one domain

Basic Analysis

In [38]:
page_domain_mainlyfromone = page_domain[(page_domain['page_name'] == '100 Percent FED Up') | (page_domain['page_name'] == 'Abolish The IRS') |(page_domain['page_name'] == 'America is RIGHT') |(page_domain['page_name'] == 'Last American Patriots') |(page_domain['page_name'] == 'My Favorite Gun') |(page_domain['page_name'] == 'Obama Makes Me Puke') |(page_domain['page_name'] == 'Patriot Nation')|
                                        (page_domain['page_name'] == 'Rebirth of Freedom') | (page_domain['page_name'] == 'Robertson Family Values') |(page_domain['page_name'] == 'Sean Brown') |(page_domain['page_name'] == 'Spokane Conservative Examiner') |(page_domain['page_name'] == 'Tell Me Now') |(page_domain['page_name'] == 'The Last Great Stand') |(page_domain['page_name'] == 'The New Resistance')|
                                        (page_domain['page_name'] == 'The Political Insider') | (page_domain['page_name'] == 'Girls Just Wanna Have Guns') |(page_domain['page_name'] == 'Angry American Patriots') |(page_domain['page_name'] == 'Ann Romney Fan Site') |
                         (page_domain['page_name'] == 'Dc Gazette') |(page_domain['page_name'] == 'Democrats Driving Forward to Victory') |(page_domain['page_name'] == 'End The Fed')|(page_domain['page_name'] == 'God King')|(page_domain['page_name'] == 'Trina')]

mainlyfromone_page = list(page_domain_mainlyfromone.page_name.unique())
mainlyfromwhat_domain = []
for i in mainlyfromone_page:
    test = page_domain_mainlyfromone[page_domain_mainlyfromone['page_name']==i]
    maximun = test.loc[test[0].idxmax()]
    mainlyfromwhat_domain.append(maximun['domain'])
In [39]:
first_post_create_time = pd.DataFrame()
for i in mainlyfromone_page:
    first_created = post_sort_by_created_time[post_sort_by_created_time['page_name']==i].head(1)
    first_post_create_time = pd.concat([first_post_create_time,first_created])
first_post_create_time = first_post_create_time[['page_name','post_created_date_CT']]
first_post_create_time.sort_values('post_created_date_CT')
Out[39]:
page_name post_created_date_CT
23167 The New Resistance 2014-12-31
96114 Sean Brown 2014-12-31
22148 Rebirth of Freedom 2014-12-31
52773 Ann Romney Fan Site 2015-01-01
28401 Patriot Nation 2015-01-10
37924 Girls Just Wanna Have Guns 2015-01-19
131426 Angry American Patriots 2015-01-22
112917 The Last Great Stand 2015-01-27
32623 Obama Makes Me Puke 2015-02-08
103306 Last American Patriots 2015-02-21
123107 Spokane Conservative Examiner 2015-03-21
21810 100 Percent FED Up 2015-08-27
84882 Dc Gazette 2015-12-22
18710 The Political Insider 2016-01-13
120944 My Favorite Gun 2016-01-20
119278 Abolish The IRS 2016-01-20
274 God King 2016-02-08
79886 Robertson Family Values 2016-02-22
14394 Trina 2016-02-27
118782 America is RIGHT 2016-03-25
28897 Tell Me Now 2016-04-26
17613 Democrats Driving Forward to Victory 2016-10-01
4105 End The Fed 2017-01-03

Plots

In [40]:
mainlyfromone = politifact_with_fake_domain[(politifact_with_fake_domain['page_name'] == '100 Percent FED Up') | (politifact_with_fake_domain['page_name'] == 'Abolish The IRS') |(politifact_with_fake_domain['page_name'] == 'America is RIGHT') |(politifact_with_fake_domain['page_name'] == 'Last American Patriots') |(politifact_with_fake_domain['page_name'] == 'My Favorite Gun') |(politifact_with_fake_domain['page_name'] == 'Obama Makes Me Puke') |(politifact_with_fake_domain['page_name'] == 'Patriot Nation')|
                                        (politifact_with_fake_domain['page_name'] == 'Rebirth of Freedom') | (politifact_with_fake_domain['page_name'] == 'Robertson Family Values') |(politifact_with_fake_domain['page_name'] == 'Sean Brown') |(politifact_with_fake_domain['page_name'] == 'Spokane Conservative Examiner') |(politifact_with_fake_domain['page_name'] == 'Tell Me Now') |(politifact_with_fake_domain['page_name'] == 'The Last Great Stand') |(politifact_with_fake_domain['page_name'] == 'The New Resistance')|
                                        (politifact_with_fake_domain['page_name'] == 'The Political Insider') | (politifact_with_fake_domain['page_name'] == 'Girls Just Wanna Have Guns') |(politifact_with_fake_domain['page_name'] == 'Angry American Patriots') |(politifact_with_fake_domain['page_name'] == 'Ann Romney Fan Site') |
                         (politifact_with_fake_domain['page_name'] == 'Dc Gazette') |(politifact_with_fake_domain['page_name'] == 'Democrats Driving Forward to Victory') |(politifact_with_fake_domain['page_name'] == 'End The Fed')|(page_domain['page_name'] == 'God King')|(politifact_with_fake_domain['page_name'] == 'Trina')]
mainlyfromone
Out[40]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count domain category type
12 591402597574018 Tell Me Now 591402597574018_1065863346794605 link This White House Petition to CHARGE Hillary Re... EAT. THIS. HILDEBEEST. \nLet's push this OVER ... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/white-house-peti... Hillary may have gotten her way with the FBI, ... ... 2016-07-07T20:00:00Z 2016-07-09T11:11:32Z 2016-07-07 2016-07-09 2016-07-08T01:00:00Z 2016-07-09T16:11:32Z 349481.0 ClashDaily.com News/Media Website media
30 112723252096438 The Political Insider 112723252096438_1061186837250070 link If Trump Is So Awful, Why Are His Kids So Awes... Here's a great question...please forward this ... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/03/if-trump-is-so-a... NaN ... 2016-03-06T18:33:01Z 2016-03-08T17:40:30Z 2016-03-06 2016-03-08 2016-03-07T00:33:01Z 2016-03-08T23:40:30Z 1010747.0 ClashDaily.com News/Media Website media
38 112723252096438 The Political Insider 112723252096438_1146533155382104 link This White House Petition to CHARGE Hillary Re... Let's push this OVER 30 Million! 'Like & Share... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/white-house-peti... Hillary may have gotten her way with the FBI, ... ... 2016-07-08T17:00:00Z 2016-07-09T18:50:18Z 2016-07-08 2016-07-09 2016-07-08T22:00:00Z 2016-07-09T23:50:18Z 1024760.0 ClashDaily.com News/Media Website media
50 112723252096438 The Political Insider 112723252096438_1253098804725538 link DEAR TRUMP HATERS: If Trump Is ‘Evil’ Then WHY... I believe Spiderman once said that a “tree is ... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/dear-trump-hater... NaN ... 2016-11-11T02:30:01Z 2016-11-11T02:30:01Z 2016-11-11 2016-11-11 2016-11-11T08:30:01Z 2016-11-11T08:30:01Z 684362.0 ClashDaily.com News/Media Website media
53 112723252096438 The Political Insider 112723252096438_1155268367841916 link PATRIOTS: Ben Carson Linked Hillary To LUCIFER... DANG. Ben went rogue on The Hildebeest. \n\nWa... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/patriots-ben-car... Ben Carson just called out Hillary and linked ... ... 2016-07-21T23:00:00Z 2016-07-23T22:39:08Z 2016-07-21 2016-07-23 2016-07-22T04:00:00Z 2016-07-24T03:39:08Z 915310.0 ClashDaily.com News/Media Website media
65 721683147909323 The New Resistance 721683147909323_1276732035737762 link Liberals IRATE After Trump Sends 92 Muslims Pa... Islamists and liberals are losing their minds ... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/trump-92-muslims-airport/ Islamists and liberals are losing their minds ... ... 2017-01-26T16:30:17Z 2017-01-30T07:18:42Z 2017-01-26 2017-01-30 2017-01-26T22:30:17Z 2017-01-30T13:18:42Z 212803.0 MadWorldNews.com Community group
74 721683147909323 The New Resistance 721683147909323_1286162778128021 link Vet-Owned Coffee Co's Counter-Offer Has '10,00... After liberal Starbucks announced they will de... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/vet-coffee-refugees-st... After liberal Starbucks announced they will de... ... 2017-02-03T19:30:00Z 2017-02-07T07:49:35Z 2017-02-03 2017-02-07 2017-02-04T01:30:00Z 2017-02-07T13:49:35Z 212803.0 MadWorldNews.com Community group
78 591402597574018 Tell Me Now 591402597574018_1046727372041536 link QUESTION: Should Welfare ABUSERS Be ARRESTED? This is a HOT potato. \nThis deserves ... oh .... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/06/question-welfare... Do you think that those who abuse the system s... ... 2016-06-03T20:00:00Z 2016-06-12T14:11:50Z 2016-06-03 2016-06-12 2016-06-04T01:00:00Z 2016-06-12T19:11:50Z 183378.0 ClashDaily.com News/Media Website media
95 112723252096438 The Political Insider 112723252096438_1153266641375422 link QUESTION: Do You AGREE With Trump That Rosie O... Rosie O’Donnell just unleashed a new attack on... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/05/question-agree-t... You're not going to believe her latest obsceni... ... 2016-07-19T02:33:00Z 2016-07-23T15:38:33Z 2016-07-19 2016-07-23 2016-07-19T07:33:00Z 2016-07-23T20:38:33Z 915310.0 ClashDaily.com News/Media Website media
98 591402597574018 Tell Me Now 591402597574018_1027183650662575 link QUESTION: Should These Men Get The DEATH PENAL... Share your thoughts! clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/04/question-should-... NaN ... 2016-05-01T02:45:00Z 2016-05-02T07:12:56Z 2016-05-01 2016-05-02 2016-05-01T07:45:00Z 2016-05-02T12:12:56Z 523193.0 ClashDaily.com News/Media Website media
112 591402597574018 Tell Me Now 591402597574018_1268339823213622 link Sheriff Clarke Says, ‘ALL Cop Killers Should G... Share your thoughts! Should cop killers get th... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/12/sheriff-clarke-s... We need to decide... what is a cop's life REAL... ... 2016-12-18T02:00:01Z 2016-12-22T10:18:45Z 2016-12-18 2016-12-22 2016-12-18T08:00:01Z 2016-12-22T16:18:45Z 287669.0 ClashDaily.com News/Media Website media
156 112723252096438 The Political Insider 112723252096438_1251181371583948 link JOURNALISM IS DEAD: It Died KISSING Hillary’s ... When did it happen? And how did it die? \nThis... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/08/journalism-is-de... NaN ... 2016-11-09T02:30:00Z 2016-11-10T21:28:46Z 2016-11-09 2016-11-10 2016-11-09T08:30:00Z 2016-11-11T03:28:46Z 1698738.0 ClashDaily.com News/Media Website media
157 591402597574018 Tell Me Now 591402597574018_1074432912604315 link DEAR TRUMP HATERS: If Trump Is ‘Evil’ Then WHY... Jesus said, 'a tree is known by its fruit.' Do... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/dear-trump-hater... If you believe Hillary and The Never Trumpers,... ... 2016-07-21T20:00:00Z 2016-07-23T13:46:24Z 2016-07-21 2016-07-23 2016-07-22T01:00:00Z 2016-07-23T18:46:24Z 450992.0 ClashDaily.com News/Media Website media
184 591402597574018 Tell Me Now 591402597574018_1073256869388586 link QUESTION: Do You LOVE ‘Bikers for Trump’ And T... THESE. DUDES. ARE. AWESOME! \n\nDid you SEE th... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/question-love-bi... This may just be the most awesome group of Tru... ... 2016-07-20T02:00:00Z 2016-07-21T21:01:15Z 2016-07-20 2016-07-21 2016-07-20T07:00:00Z 2016-07-22T02:01:15Z 338050.0 ClashDaily.com News/Media Website media
195 112723252096438 The Political Insider 112723252096438_1233818279986924 link LMAO: TV Star Says ‘I’d Rather Be Grabbed By T... THIS. IS. HILARIOUS. Is Katie right or ridicul... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/10/lmao-tv-star-say... NaN ... 2016-10-21T02:32:08Z 2016-10-22T11:19:10Z 2016-10-21 2016-10-22 2016-10-21T07:32:08Z 2016-10-22T16:19:10Z 1168273.0 ClashDaily.com News/Media Website media
203 721683147909323 The New Resistance 721683147909323_1189519851125648 link Bold Man Stands Before Anti-Trump Brats Holdin... While hostile anti-Trump protests and riots ra... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/anti-trump-brats-sign-... While hostile anti-Trump protests and riots ra... ... 2016-11-11T16:30:15Z 2016-11-14T22:21:27Z 2016-11-11 2016-11-14 2016-11-11T22:30:15Z 2016-11-15T04:21:27Z 212803.0 MadWorldNews.com Community group
231 112723252096438 The Political Insider 112723252096438_1245844382117647 link VIRAL: 13yr. Old Trump Girl HAMMERS Hillary – ... THIS LITTLE FIREBRAND IS MY NEW HERO. This des... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/10/viral-13yr-old-t... NaN ... 2016-11-03T02:30:00Z 2016-11-03T02:30:00Z 2016-11-03 2016-11-03 2016-11-03T07:30:00Z 2016-11-03T07:30:00Z 1364461.0 ClashDaily.com News/Media Website media
237 721683147909323 The New Resistance 721683147909323_1293240227420276 link Marine Dad Makes School PAY After Pushing Isla... All across the country we’ve heard stories of ... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/marine-dad-school-push... All across the country we’ve heard stories of ... ... 2016-01-01T11:00:00Z 2017-02-14T20:52:43Z 2016-01-01 2017-02-14 2016-01-01T17:00:00Z 2017-02-15T02:52:43Z 234905.0 MadWorldNews.com Community group
242 591402597574018 Tell Me Now 591402597574018_1076159935764946 link Would You Support a Bill That Makes Killing Po... YES! clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/sen-cornyns-back... SEN. CORNYN'S 'BACK THE BLUE ACT’ Makes Killin... ... 2016-07-25T02:39:00Z 2016-07-26T22:49:24Z 2016-07-25 2016-07-26 2016-07-25T07:39:00Z 2016-07-27T03:49:24Z 538928.0 ClashDaily.com News/Media Website media
279 721683147909323 The New Resistance 721683147909323_1303803266363972 link Muslims Demand "Bigoted" Church Sign Removal, ... Muslims have taken to social media and major n... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/muslims-bigoted-church... Muslims and their leftist sympathizers have ta... ... 2016-05-13T11:00:00Z 2017-03-25T10:46:06Z 2016-05-13 2017-03-25 2016-05-13T16:00:00Z 2017-03-25T15:46:06Z 234905.0 MadWorldNews.com Community group
281 591402597574018 Tell Me Now 591402597574018_1051059448274995 link QUESTION: Do You AGREE With Trump That Rosie O... Share your thoughts! clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/05/question-agree-t... You're not going to believe her latest obsceni... ... 2016-06-12T02:40:29Z 2016-06-29T10:39:19Z 2016-06-12 2016-06-29 2016-06-12T07:40:29Z 2016-06-29T15:39:19Z 183378.0 ClashDaily.com News/Media Website media
283 721683147909323 The New Resistance 721683147909323_885440414866928 link He Thought All Eyes Were On Injured Teammate, ... A photo is going viral after a picture was tak... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/injured-teammate-photo/ A photo is going viral after a picture was tak... ... 2015-09-06T13:30:00Z 2015-09-07T22:31:52Z 2015-09-06 2015-09-07 2015-09-06T18:30:00Z 2015-09-08T03:31:52Z 187802.0 MadWorldNews.com Community group
288 591402597574018 Tell Me Now 591402597574018_1141487702565502 link DEAR TRUMP HATERS: If Trump Is ‘Evil’ Then WHY... One of my old and wise, now deceased, mentors ... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/dear-trump-hater... If you believe Hillary and The Never Trumpers,... ... 2016-10-18T13:00:00Z 2016-10-20T11:04:22Z 2016-10-18 2016-10-20 2016-10-18T18:00:00Z 2016-10-20T16:04:22Z 784263.0 ClashDaily.com News/Media Website media
292 311190048935167 100 Percent FED Up 311190048935167_1184685238252306 link Armed Citizen Shoots and Kills Suspect Who Was... Armed Citizen Shoots and Kills Suspect Who Was... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/armed-citizen-shoots-k... This is what the 2nd Amendment is all about! ... 2016-11-15T13:00:00Z 2016-11-18T20:21:20Z 2016-11-15 2016-11-18 2016-11-15T19:00:00Z 2016-11-19T02:21:20Z 356173.0 FreedomDaily.com Media/News/Publishing media
297 591402597574018 Tell Me Now 591402597574018_1146323838748555 link QUESTION: Would You Like To See Trump Win Just... YES clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/10/question-like-se... The pundits are saying it's all over for Trump... ... 2016-10-22T13:00:09Z 2016-10-24T10:34:38Z 2016-10-22 2016-10-24 2016-10-22T18:00:09Z 2016-10-24T15:34:38Z 609727.0 ClashDaily.com News/Media Website media
298 591402597574018 Tell Me Now 591402597574018_1070142739699999 link PATRIOTS: Should Trump Fly The #Benghazi Victi... WHAT. A. GREAT. IDEA! clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/07/patriots-trump-f... It looks like that would really make a statement. ... 2016-07-14T20:00:00Z 2016-07-17T04:53:49Z 2016-07-14 2016-07-17 2016-07-15T01:00:00Z 2016-07-17T09:53:49Z 348743.0 ClashDaily.com News/Media Website media
316 591402597574018 Tell Me Now 591402597574018_1136487639732175 link LMAO: TV Star Says ‘I’d Rather Be Grabbed By T... THIS. IS. HILARIOUS. Is Katie right or ridicul... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/10/lmao-tv-star-say... Katie Hopkins, former Apprentice UK contestant... ... 2016-10-14T02:00:02Z 2016-10-15T21:20:40Z 2016-10-14 2016-10-15 2016-10-14T07:00:02Z 2016-10-16T02:20:40Z 276623.0 ClashDaily.com News/Media Website media
317 311190048935167 100 Percent FED Up 311190048935167_1181048015282695 link YES! Rosie O’Donnell Confirms She’s Moving Fro... YES! Rosie O’Donnell Confirms She’s Moving Fro... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/yes-rosie-odonnell-con... Pack your sh*t and go! Rosie O is gonna hit th... ... 2016-11-12T13:16:37Z 2016-11-14T09:06:17Z 2016-11-12 2016-11-14 2016-11-12T19:16:37Z 2016-11-14T15:06:17Z 1687606.0 FreedomDaily.com Media/News/Publishing media
329 112723252096438 The Political Insider 112723252096438_1235802313121854 link QUESTION: Would You Like To See Trump Win Just... YES clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2016/10/question-like-se... The pundits are saying it's all over for Trump... ... 2016-10-23T02:33:01Z 2016-10-24T18:51:32Z 2016-10-23 2016-10-24 2016-10-23T07:33:01Z 2016-10-24T23:51:32Z 1231579.0 ClashDaily.com News/Media Website media
332 721683147909323 The New Resistance 721683147909323_1226261804118119 link Soldiers HUMILIATE Obama By Doing 1 Thing For ... Proving himself to be a country-loving America... madworldnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/soldiers-humiliate-oba... Proving himself to be a country-loving America... ... 2016-12-11T14:30:00Z 2016-12-15T21:31:15Z 2016-12-11 2016-12-15 2016-12-11T20:30:00Z 2016-12-16T03:31:15Z 212803.0 MadWorldNews.com Community group
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
132294 146612062031906 Spokane Conservative Examiner 146612062031906_1135990266427409 link Supreme Court Sides With Obama Admin In Big Is... Supreme Court Sides With Obama Admin In Big Is... www.bb4sp.com https://fbexternal-a.akamaihd.net/safe_image.p... http://www.bb4sp.com/supreme-court-sides-with-... The U.S. Supreme Court has struck down a contr... ... 2015-06-10T05:30:17Z 2015-06-10T05:30:17Z 2015-06-10 2015-06-10 2015-06-10T10:30:17Z 2015-06-10T10:30:17Z 5463.0 BB4SP.com News/Media Website media
132295 312531385450925 The Last Great Stand 312531385450925_934259086611482 link 9 Reasons the Terrorist Attacks in Paris Could... 9 Reasons the Terrorist Attacks in Paris Could... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1QnzFrx My heart goes out to anyone who lost a family ... ... 2015-11-16T09:33:39Z 2015-11-16T09:33:39Z 2015-11-16 2015-11-16 2015-11-16T15:33:39Z 2015-11-16T15:33:39Z 8055.0 BeforeItsNews.com Politician media
132296 312531385450925 The Last Great Stand 312531385450925_1022081877829202 link Jim Willie and Will The U.S. Collapse Due To I... Jim Willie and Will The U.S. Collapse Due To I... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1pDIRwF In this interview below between Rick Wile of T... ... 2016-04-27T04:58:31Z 2016-04-27T04:58:31Z 2016-04-27 2016-04-27 2016-04-27T09:58:31Z 2016-04-27T09:58:31Z 22852.0 BeforeItsNews.com Politician media
132297 312531385450925 The Last Great Stand 312531385450925_924625567574834 link How Aliens Helped to Build Earth’s Ancient Pyr... How Aliens Helped to Build Earth’s Ancient Pyr... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1LndPjk EVERYTHING WE HAVE BEEN TAUGHT ABOUT HUMAN ORI... ... 2015-10-24T06:40:17Z 2015-10-24T06:40:17Z 2015-10-24 2015-10-24 2015-10-24T11:40:17Z 2015-10-24T11:40:17Z 3727.0 BeforeItsNews.com Politician media
132298 312531385450925 The Last Great Stand 312531385450925_875427919161266 link Obama Scheming with Financial Institutions to ... NaN beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://thelastgreatstand.tumblr.com/post/12325... What do you get when you mix the latest versio... ... 2015-07-05T00:14:45Z 2015-07-05T00:14:45Z 2015-07-05 2015-07-05 2015-07-05T05:14:45Z 2015-07-05T05:14:45Z 6106.0 BeforeItsNews.com Politician media
132299 312531385450925 The Last Great Stand 312531385450925_942872432416814 link Peter Schiff and "11 Alarms Being Ignored As T... Peter Schiff and “11 Alarms Being Ignored As T... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1Qh2fcG In the following video, Peter Schiff pokes fun... ... 2015-12-03T12:49:23Z 2015-12-03T12:49:23Z 2015-12-03 2015-12-03 2015-12-03T18:49:23Z 2015-12-03T18:49:23Z 13809.0 BeforeItsNews.com Politician media
132300 312531385450925 The Last Great Stand 312531385450925_911718795532178 link Top 10 Extremely Bizarre Phobias People Have –... SOME OF THESE WILL MAKE YOU LAUGH (#2); SOME M... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/alternative/2015/09/t... In a world where just about every actual news ... ... 2015-09-23T13:02:08Z 2015-09-23T13:02:08Z 2015-09-23 2015-09-23 2015-09-23T18:02:08Z 2015-09-23T18:02:08Z 3108.0 BeforeItsNews.com Politician media
132301 312531385450925 The Last Great Stand 312531385450925_922013361169388 link Thirty-one Rare and Interesting Pictures Of th... 31 Rare and Interesting Pictures Of The World ... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/alternative/2015/07/3... CHECK OUT OTHER STORIES BY THE UN-SILENT MAJOR... ... 2015-10-17T16:00:14Z 2015-10-17T16:00:14Z 2015-10-17 2015-10-17 2015-10-17T21:00:14Z 2015-10-17T21:00:14Z 9719.0 BeforeItsNews.com Politician media
132302 312531385450925 The Last Great Stand 312531385450925_911855005518557 link 10 Extremely Bizarre Phobias People Have – #2 ... Top 10 Extremely Bizarre Phobias People Have –... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/alternative/2015/09/t... In a world where just about every actual news ... ... 2015-09-23T21:00:07Z 2015-09-23T21:00:07Z 2015-09-23 2015-09-23 2015-09-24T02:00:07Z 2015-09-24T02:00:07Z 3108.0 BeforeItsNews.com Politician media
132303 312531385450925 The Last Great Stand 312531385450925_890496244321100 link Why Are The Illuminati Planning To Crash the G... NaN beforeitsnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://thelastgreatstand.tumblr.com/post/12616... Why Are The Illuminati Planning To Crash the G... ... 2015-08-08T04:33:01Z 2015-08-08T04:33:01Z 2015-08-08 2015-08-08 2015-08-08T09:33:01Z 2015-08-08T09:33:01Z 4367.0 BeforeItsNews.com Politician media
132304 146612062031906 Spokane Conservative Examiner 146612062031906_1431105400249226 link WOW! State Department Spokesperson Thinks The ... “This administration fiddles while Rome burns…... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/state-department-spokesperson... Welcome to the State Department. This administ... ... 2016-08-05T10:30:00Z 2016-08-05T10:30:00Z 2016-08-05 2016-08-05 2016-08-05T15:30:00Z 2016-08-05T15:30:00Z 8225.0 BB4SP.com News/Media Website media
132305 146612062031906 Spokane Conservative Examiner 146612062031906_1362424760450624 link 2013 West Texas Fertilizer Blast That Killed 1... “The ATF government agents are super fast at t... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/2013-west-texas-fertilizer-bl... Officials launched a hunt Wednesday for possib... ... 2016-05-12T10:30:00Z 2016-05-12T10:30:00Z 2016-05-12 2016-05-12 2016-05-12T15:30:00Z 2016-05-12T15:30:00Z 9442.0 BB4SP.com News/Media Website media
132307 312531385450925 The Last Great Stand 312531385450925_912281835475874 link Dying US Political Prisoner at 87 (Peter Schif... Blind and Dying US Political Prisoner at 87 (P... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://buff.ly/1Mti64W Do you want to know what a lawless tyrannical ... ... 2015-09-25T02:59:38Z 2015-09-25T02:59:38Z 2015-09-25 2015-09-25 2015-09-25T07:59:38Z 2015-09-25T07:59:38Z 2953.0 BeforeItsNews.com Politician media
132308 146612062031906 Spokane Conservative Examiner 146612062031906_1424280810931685 link Inmates Take Over Portion Of A Jail In Chicago... “Officials said they are working to resolve th... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/cook-county-jail-inmates-chic... Officials said they are working to resolve the... ... 2016-07-28T21:30:00Z 2016-07-28T21:30:00Z 2016-07-28 2016-07-28 2016-07-29T02:30:00Z 2016-07-29T02:30:00Z 12819.0 BB4SP.com News/Media Website media
132309 312531385450925 The Last Great Stand 312531385450925_937766779594046 link 5-Year-Old Genius Has Scientists Believing Tha... 5-Year-Old Genius Has Scientists Believing Tha... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1LrVpL2 No doubt this kid is most impressive. I’m push... ... 2015-11-22T08:50:28Z 2015-11-22T08:50:28Z 2015-11-22 2015-11-22 2015-11-22T14:50:28Z 2015-11-22T14:50:28Z 14210.0 BeforeItsNews.com Politician media
132310 312531385450925 The Last Great Stand 312531385450925_957931900910867 link Police To Begin Trolling Even People's "Hidden... Police To Begin Trolling Even People’s “Hidden... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1R2zp1F In the first video below, RT discusses a new b... ... 2016-01-02T08:49:23Z 2016-01-02T14:25:19Z 2016-01-02 2016-01-02 2016-01-02T14:49:23Z 2016-01-02T20:25:19Z 6158.0 BeforeItsNews.com Politician media
132311 312531385450925 The Last Great Stand 312531385450925_927025187334872 link Cleric Says: "Muslims Have the Right to Kill A... “Moderate” Cleric Says: “Muslims Have the Righ... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/20eHFON Look at that picture above. Those “peaceful Mu... ... 2015-10-30T04:10:22Z 2015-10-30T04:10:22Z 2015-10-30 2015-10-30 2015-10-30T09:10:22Z 2015-10-30T09:10:22Z 3239.0 BeforeItsNews.com Politician media
132312 149817218374125 Girls Just Wanna Have Guns 149817218374125_963106277045211 link 10 REASONS: Why I Could Never Be The Pope ⋆ Do... I appreciate Pope Francis' stand for trad marr... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://ow.ly/SIWEZ I'm glad, for many reasons, that Boehner resig... ... 2015-09-27T17:40:21Z 2015-09-27T17:51:34Z 2015-09-27 2015-09-27 2015-09-27T22:40:21Z 2015-09-27T22:51:34Z 11405.0 ClashDaily.com Cause group
132313 312531385450925 The Last Great Stand 312531385450925_931396080231116 link 10 Ancient Settlements That Were Abandoned for... 10 Ancient Settlements That Were Abandoned for... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1PvfhTx (Image: Carlos Adampol, cc-sa-4.0) The ten anc... ... 2015-11-09T09:20:58Z 2015-11-09T09:20:58Z 2015-11-09 2015-11-09 2015-11-09T15:20:58Z 2015-11-09T15:20:58Z 2964.0 BeforeItsNews.com Politician media
132314 312531385450925 The Last Great Stand 312531385450925_945083818862342 link China Knocking on the Door of Global Reserve-C... China Knocking on the Door of Global Reserve-C... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/politics/2015/08/chin... FOR MORE NEWS BY VOICE OF REASON CLICK HERE! B... ... 2015-12-08T06:00:16Z 2015-12-08T06:00:16Z 2015-12-08 2015-12-08 2015-12-08T12:00:16Z 2015-12-08T12:00:16Z 8946.0 BeforeItsNews.com Politician media
132315 425390150874429 Sean Brown 425390150874429_847069882039785 link Teen’s Final Day Of School Becomes ‘Extreme’ N... On her last day of school before graduation, a... madworldnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://madworldnews.com/teens-final-day-school... On her last day of school before graduation, a... ... 2015-05-20T17:36:54Z 2015-05-20T17:36:54Z 2015-05-20 2015-05-20 2015-05-20T22:36:54Z 2015-05-20T22:36:54Z 1515.0 MadWorldNews.com Journalist figure
132316 312531385450925 The Last Great Stand 312531385450925_933402920030432 link UFO Activists Excited About Hillary Presidency... UFO Activists Excited About Hillary Presidency... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1NScsMv Illustration by Ivylise Simones; Clinton: Bria... ... 2015-11-14T08:36:11Z 2015-11-14T08:36:11Z 2015-11-14 2015-11-14 2015-11-14T14:36:11Z 2015-11-14T14:36:11Z 5854.0 BeforeItsNews.com Politician media
132317 751413538254047 America is RIGHT 751413538254047_1193759067352823 link Where Are Barack And Michelle, Black Lives Mat... Where Are Barack And Michelle, Black Lives Mat... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/barack-michelle-black-... I'm sure you've all realized by now that to li... ... 2016-05-31T08:38:28Z 2016-05-31T08:38:28Z 2016-05-31 2016-05-31 2016-05-31T13:38:28Z 2016-05-31T13:38:28Z 12306.0 FreedomDaily.com Media/News/Publishing group
132318 312531385450925 The Last Great Stand 312531385450925_922652831105441 link The TPP Has a Secret Clause to Limit Free Spee... The TPP Has a Secret Clause to Limit Free Spee... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://beforeitsnews.com/politics/2015/10/the-... As we head into what is “scheduled” to be Obam... ... 2015-10-19T09:00:42Z 2015-10-19T23:28:04Z 2015-10-19 2015-10-19 2015-10-19T14:00:42Z 2015-10-20T04:28:04Z 9719.0 BeforeItsNews.com Politician media
132319 146612062031906 Spokane Conservative Examiner 146612062031906_1474129272613505 link Device Explodes Along Military 5K Route, 2nd D... Device Explodes Along Military 5K Route, 2nd D... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/device-explodes-along-militar... Luckily no one was in the area when the device... ... 2016-09-18T02:00:15Z 2016-09-18T02:00:15Z 2016-09-18 2016-09-18 2016-09-18T07:00:15Z 2016-09-18T07:00:15Z 7819.0 BB4SP.com News/Media Website media
132320 312531385450925 The Last Great Stand 312531385450925_1004374316266625 link Dr. Jim Willie - Secret Meeting at the G20 to ... Dr. Jim Willie – Secret Meeting at the G20 to ... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1UUTyah In the following video, USA Watchdog talks to ... ... 2016-03-28T08:36:26Z 2016-03-28T08:36:26Z 2016-03-28 2016-03-28 2016-03-28T13:36:26Z 2016-03-28T13:36:26Z 40831.0 BeforeItsNews.com Politician media
132321 425390150874429 Sean Brown 425390150874429_855493394530767 link Cameras Catch ‘CREEPY’ Thing Man Did In Walmar... Police were recently on the lookout for a man ... madworldnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://madworldnews.com/cameras-creepy-man-wal... Police were recently on the lookout for a man ... ... 2015-06-06T12:37:21Z 2015-06-06T12:59:25Z 2015-06-06 2015-06-06 2015-06-06T17:37:21Z 2015-06-06T17:59:25Z 1906.0 MadWorldNews.com Journalist figure
132322 146612062031906 Spokane Conservative Examiner 146612062031906_1487477401278692 link Hillary Mocks Sanders Supporters In Leaked Fun... “She mocks the millennials while her supporter... bb4sp.com https://external.xx.fbcdn.net/safe_image.php?d... http://bb4sp.com/hillary-mocks-sanders-support... She mocks the millennials while her supporters... ... 2016-10-01T12:30:01Z 2016-10-01T12:30:01Z 2016-10-01 2016-10-01 2016-10-01T17:30:01Z 2016-10-01T17:30:01Z 4655.0 BB4SP.com News/Media Website media
132323 312531385450925 The Last Great Stand 312531385450925_927231550647569 link 6 Ways To Show The World Is In Cognitive Disso... 6 Ways To Show The World Is In Cognitive Disso... beforeitsnews.com https://fbexternal-a.akamaihd.net/safe_image.p... http://beforeitsnews.com/politics/2015/10/6-wa... Wait up, hold on, hold the phone here! Why is ... ... 2015-10-30T16:00:45Z 2015-10-30T16:00:45Z 2015-10-30 2015-10-30 2015-10-30T21:00:45Z 2015-10-30T21:00:45Z 2957.0 BeforeItsNews.com Politician media
132324 312531385450925 The Last Great Stand 312531385450925_1005211816182875 link Jim Willie and How the Loss of the US Dollar a... Jim Willie and How the Loss of the US Dollar a... beforeitsnews.com https://external.xx.fbcdn.net/safe_image.php?d... http://bit.ly/1MHUpEO In the following video, Dr. Jim Willie is a gu... ... 2016-03-29T10:40:52Z 2016-03-29T10:40:52Z 2016-03-29 2016-03-29 2016-03-29T15:40:52Z 2016-03-29T15:40:52Z 40831.0 BeforeItsNews.com Politician media

58779 rows × 24 columns

In [41]:
plt.rcParams['figure.figsize'] = [60, 50]
times = pd.DataFrame()
for i in mainlyfromone_page:
    times = mainlyfromone[mainlyfromone['page_name']==i].groupby('post_created_date_CT').mean()
    times['count'] = mainlyfromone[mainlyfromone['page_name']==i].groupby('post_created_date_CT').size()
    times.reset_index(level=0, inplace=True)
    times=times[['post_created_date_CT','count']]
    times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
    mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'], color = np.random.rand(3,),ls = 'solid')
In [42]:
times = pd.DataFrame()
times = mainlyfromone.groupby('post_created_date_CT').mean()
times['count'] = mainlyfromone.groupby('post_created_date_CT').size()
times.reset_index(level=0, inplace=True)
times=times[['post_created_date_CT','count']]
times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
plt.rcParams['figure.figsize'] = [25, 12]
mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'],'b-')
Out[42]:
[<matplotlib.lines.Line2D at 0x7f7ba4f37748>]
In [43]:
mainlyfromone_page
mainlyfromwhat_domain
mainlyfromone_data = pd.DataFrame()
for i in range(23):
    test = mainlyfromone[(mainlyfromone['page_name']==mainlyfromone_page[i])&(mainlyfromone['domain']!=mainlyfromwhat_domain[i])]
    mainlyfromone_data = pd.concat([mainlyfromone_data,test])
mainlyfromone_data
Out[43]:
page_id page_name post_id post_type post_name post_message post_caption post_picture post_link post_description ... post_created_time_CT post_updated_time_CT post_created_date_CT post_updated_date_CT post_created_time post_updated_time page_talking_about_count domain category type
292 311190048935167 100 Percent FED Up 311190048935167_1184685238252306 link Armed Citizen Shoots and Kills Suspect Who Was... Armed Citizen Shoots and Kills Suspect Who Was... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/armed-citizen-shoots-k... This is what the 2nd Amendment is all about! ... 2016-11-15T13:00:00Z 2016-11-18T20:21:20Z 2016-11-15 2016-11-18 2016-11-15T19:00:00Z 2016-11-19T02:21:20Z 356173.0 FreedomDaily.com Media/News/Publishing media
317 311190048935167 100 Percent FED Up 311190048935167_1181048015282695 link YES! Rosie O’Donnell Confirms She’s Moving Fro... YES! Rosie O’Donnell Confirms She’s Moving Fro... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/yes-rosie-odonnell-con... Pack your sh*t and go! Rosie O is gonna hit th... ... 2016-11-12T13:16:37Z 2016-11-14T09:06:17Z 2016-11-12 2016-11-14 2016-11-12T19:16:37Z 2016-11-14T15:06:17Z 1687606.0 FreedomDaily.com Media/News/Publishing media
819 311190048935167 100 Percent FED Up 311190048935167_1179785018742328 link Trump Announces Trey Gowdy Is Finalist For One... Trump Announces Trey Gowdy Is Finalist For One... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/trump-announces-trey-g... Hillary is not going to sleep well over this! ... 2016-11-11T13:00:00Z 2016-11-13T19:48:40Z 2016-11-11 2016-11-13 2016-11-11T19:00:00Z 2016-11-14T01:48:40Z 356173.0 FreedomDaily.com Media/News/Publishing media
1612 311190048935167 100 Percent FED Up 311190048935167_1170058743048289 link Liberals at 'The View' Tried to Bully Trumps M... Whoopi and Her Liberal Hacks at 'The View' Tri... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/liberals-view-tried-bu... She goes OFF. ... 2016-11-03T13:00:00Z 2016-11-08T14:40:44Z 2016-11-03 2016-11-08 2016-11-03T18:00:00Z 2016-11-08T20:40:44Z 356173.0 FreedomDaily.com Media/News/Publishing media
2035 311190048935167 100 Percent FED Up 311190048935167_1187623397958490 link Freedom DAILY- Your Daily Dose Of Freedom. ** GEORGE SOROS IS BURNING **\n\nTrump has sen... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/ Freedom Daily Delivers meaningful conservative... ... 2016-11-17T17:38:14Z 2016-11-23T10:31:29Z 2016-11-17 2016-11-23 2016-11-17T23:38:14Z 2016-11-23T16:31:29Z 356173.0 FreedomDaily.com Media/News/Publishing media
2360 311190048935167 100 Percent FED Up 311190048935167_1182414141812749 link PEPSI CEO Just Made SHAMEFUL Statement About T... PEPSI CEO Just Made SHAMEFUL Statement About T... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/pepsi- I feel another boycott coming on. ... 2016-11-13T13:37:50Z 2016-11-15T09:43:49Z 2016-11-13 2016-11-15 2016-11-13T19:37:50Z 2016-11-15T15:43:49Z 1738462.0 FreedomDaily.com Media/News/Publishing media
3727 311190048935167 100 Percent FED Up 311190048935167_1171391696248327 link Breaking! Ex-Apprentice Trump Accuser Was Paid... Breaking! Ex-Apprentice Trump Accuser Was Paid... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/ex-apprentice-trump-ac... The Democratic machine has been in full overdr... ... 2016-11-04T13:00:00Z 2016-11-07T04:34:30Z 2016-11-04 2016-11-07 2016-11-04T18:00:00Z 2016-11-07T10:34:30Z 356173.0 FreedomDaily.com Media/News/Publishing media
5467 311190048935167 100 Percent FED Up 311190048935167_1190126087708221 link Pro-Trump Family Of Soldier Killed Bringing Bo... Pro-Trump Family Of Soldier Killed Bringing Bo... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/family-soldier-booed/ Only liberal scumbags and Muslims would do suc... ... 2016-11-19T12:55:55Z 2016-11-21T09:45:57Z 2016-11-19 2016-11-21 2016-11-19T18:55:55Z 2016-11-21T15:45:57Z 1078669.0 FreedomDaily.com Media/News/Publishing media
6950 311190048935167 100 Percent FED Up 311190048935167_1175298435857653 link Trey Gowdy Just Shredded Killary With His Fina... Trey Gowdy Just Shredded Killary With His Fina... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/trey-gowdy-just-shredd... Hillary left stunned! ... 2016-11-07T13:00:01Z 2016-11-08T09:43:37Z 2016-11-07 2016-11-08 2016-11-07T19:00:01Z 2016-11-08T15:43:37Z 1206851.0 FreedomDaily.com Media/News/Publishing media
7248 311190048935167 100 Percent FED Up 311190048935167_1173749806012516 link IT’S A MIRACLE! What Trump Did Last Night Will... IT’S A MIRACLE! What Trump Did Last Night Will... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/miracle-trump/ Memorial Day weekend, Riley was killed in a ca... ... 2016-11-06T09:47:00Z 2016-11-08T08:32:52Z 2016-11-06 2016-11-08 2016-11-06T15:47:00Z 2016-11-08T14:32:52Z 356173.0 FreedomDaily.com Media/News/Publishing media
10063 311190048935167 100 Percent FED Up 311190048935167_1173769912677172 link BREAKING! Criminal President Obama Commits A F... No one can believe what Obama just did on LIVE... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/breaking-criminal-pres... Obama is doing EVERYTHING to Give Hillary the ... ... 2016-11-06T11:00:00Z 2016-11-07T20:09:15Z 2016-11-06 2016-11-07 2016-11-06T17:00:00Z 2016-11-08T02:09:15Z 1064049.0 FreedomDaily.com Media/News/Publishing media
10308 311190048935167 100 Percent FED Up 311190048935167_1177676522286511 link BREAKING VIDEO: Black Lives Matter Rioting & L... BREAKING VIDEO: Black HILLARY Thugs Riot & Loo... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/black-lives-matter-rio... The domestic terrorists can be heard yelling "... ... 2016-11-09T13:00:00Z 2016-11-21T19:08:21Z 2016-11-09 2016-11-21 2016-11-09T19:00:00Z 2016-11-22T01:08:21Z 356173.0 FreedomDaily.com Media/News/Publishing media
10915 311190048935167 100 Percent FED Up 311190048935167_1176495625737934 link Blacks Chanting Black Lives Matter Attack Fema... BREAKING! Blacks Chanting Black Lives Matter A... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/blacks-chanting-black-... Unreal.... ... 2016-11-08T13:00:00Z 2016-11-10T03:31:39Z 2016-11-08 2016-11-10 2016-11-08T19:00:00Z 2016-11-10T09:31:39Z 1377906.0 FreedomDaily.com Media/News/Publishing media
11797 311190048935167 100 Percent FED Up 311190048935167_1319368341450661 link ICE Just Raided Cher's Transgender Kid, DISGUS... ICE Just Raided Cher's Transgender Kid, DISGUS... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/ice-just-raided-chers-... Cher has seen her day in the spotlight for yea... ... 2017-04-03T15:45:00Z 2017-04-03T15:45:00Z 2017-04-03 2017-04-03 2017-04-03T20:45:00Z 2017-04-03T20:45:00Z 356173.0 FreedomDaily.com Media/News/Publishing media
11961 311190048935167 100 Percent FED Up 311190048935167_1178774372176726 link BREAKING VIDEO: White Trump Supporter Beat By ... BREAKING VIDEO: White Trump Supporter Beat By ... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/trump-supporter-mob/ The disturbing video shows the man trying to g... ... 2016-11-10T14:12:00Z 2016-11-14T21:21:28Z 2016-11-10 2016-11-14 2016-11-10T20:12:00Z 2016-11-15T03:21:28Z 356173.0 FreedomDaily.com Media/News/Publishing media
13945 311190048935167 100 Percent FED Up 311190048935167_1188684651185698 link CLINTON BODY BAGS: Woman Investigating Clinton... BREAKING! Woman Investigating Clinton Foundati... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/woman-clinton-foundati... Monica Petersen was a Research Fellow at the H... ... 2016-11-18T13:07:44Z 2016-11-20T00:39:48Z 2016-11-18 2016-11-20 2016-11-18T19:07:44Z 2016-11-20T06:39:48Z 1319620.0 FreedomDaily.com Media/News/Publishing media
16751 311190048935167 100 Percent FED Up 311190048935167_1191493347571495 link This Shoe Company Just BANNED Ivanka Trump Pro... This Shoe Company Just BANNED Ivanka Trump Pro... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/shoe-company-just-bann... Liberalism is a severe mental disorder ... 2016-11-20T14:59:06Z 2016-11-23T19:09:02Z 2016-11-20 2016-11-23 2016-11-20T20:59:06Z 2016-11-24T01:09:02Z 356173.0 FreedomDaily.com Media/News/Publishing media
17591 311190048935167 100 Percent FED Up 311190048935167_974904112563754 link VIDEO: FOX NEWS Anchor Under Fire After Droppi... A simple statement made by this Fox News Ancho... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/video-fox- Once again another Fox News host is under atta... ... 2016-01-26T14:00:00Z 2016-01-27T20:35:05Z 2016-01-26 2016-01-27 2016-01-26T20:00:00Z 2016-01-28T02:35:05Z 153245.0 USHerald.com Media/News/Publishing media
18494 311190048935167 100 Percent FED Up 311190048935167_978068882247277 link This POWERFUL Letter Explains Why THIS Police ... This POWERFUL Letter Explains Why THIS Police ... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/police-officer-says-he-won... This letter from a police officer really makes... ... 2016-02-01T14:00:00Z 2016-02-02T17:28:51Z 2016-02-01 2016-02-02 2016-02-01T20:00:00Z 2016-02-02T23:28:51Z 179284.0 USHerald.com Media/News/Publishing media
21252 311190048935167 100 Percent FED Up 311190048935167_975978192456346 link VIDEO: Muslims Say America Needs Sharia Law NO... BOOM! Watch Hannity rip these ungrateful Musli... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/video-muslims-say-america-... Sean Hannity has long been a voice of reason a... ... 2016-01-28T14:00:00Z 2016-01-28T21:36:29Z 2016-01-28 2016-01-28 2016-01-28T20:00:00Z 2016-01-29T03:36:29Z 167208.0 USHerald.com Media/News/Publishing media
21944 311190048935167 100 Percent FED Up 311190048935167_975442389176593 link Welfare Queens Go ABSOLUTELY BALLISTIC After S... We LOVE the sign this grocery store put up. \n... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/welfare-queens-ballistic-a... It is important to point out that most America... ... 2016-01-27T14:00:00Z 2016-01-27T14:00:00Z 2016-01-27 2016-01-27 2016-01-27T20:00:00Z 2016-01-27T20:00:00Z 167208.0 USHerald.com Media/News/Publishing media
22777 311190048935167 100 Percent FED Up 311190048935167_977620558958776 link Obama Just Got ROCKED By U.S. Air Force's HUGE... Obama Just Got ROCKED By U.S. Air Force's HUGE... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/culture-boom-u-s-air-force... “None of these programs gives the installation... ... 2016-01-31T14:00:00Z 2016-01-31T17:22:25Z 2016-01-31 2016-01-31 2016-01-31T20:00:00Z 2016-01-31T23:22:25Z 183950.0 USHerald.com Media/News/Publishing media
23796 311190048935167 100 Percent FED Up 311190048935167_976482389072593 link Obama Bans VIDEO That Exposes Him! One Look An... One viewing of this VIDEO and you'll understan... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/obama-video-banned-by-obam... Regardless of one’s point of view about today’... ... 2016-01-29T14:00:00Z 2016-01-30T22:11:19Z 2016-01-29 2016-01-30 2016-01-29T20:00:00Z 2016-01-31T04:11:19Z 194022.0 USHerald.com Media/News/Publishing media
25633 311190048935167 100 Percent FED Up 311190048935167_978604358860396 link Judge SHREDS Mother Of 12 Kids Who Is 100% UNG... WHOA! This judge goes off on this arrogant and... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/judge-in-tampa-scolds-moth... Most would agree that raising one child proper... ... 2016-02-02T14:00:00Z 2016-02-04T04:40:54Z 2016-02-02 2016-02-04 2016-02-02T20:00:00Z 2016-02-04T10:40:54Z 190367.0 USHerald.com Media/News/Publishing media
26920 311190048935167 100 Percent FED Up 311190048935167_1183562141697949 link Miley Cyrus CRUSHED By Loss And Having To Move... Miley Cyrus CRUSHED By Loss And Having To Move... freedomdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://freedomdaily.com/miley-cyrus-cries/ BWAHAHAHAHA! Too funny not to share! LOLLLLLL!... ... 2016-11-14T13:00:00Z 2016-11-17T15:02:51Z 2016-11-14 2016-11-17 2016-11-14T19:00:00Z 2016-11-17T21:02:51Z 356173.0 FreedomDaily.com Media/News/Publishing media
40930 311190048935167 100 Percent FED Up 311190048935167_976954482358717 link These 6 Examples of Human Stupidity PERFECTLY ... Just when you think you have heard it all befo... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/these-6-examples-of-human-... Note: Number #7 had to be left out, it was jus... ... 2016-01-30T14:00:00Z 2016-01-31T01:04:31Z 2016-01-30 2016-01-31 2016-01-30T20:00:00Z 2016-01-31T07:04:31Z 194022.0 USHerald.com Media/News/Publishing media
43891 311190048935167 100 Percent FED Up 311190048935167_978988045488694 link Little Boy Asks His Dad "What is Politics?", Y... This kid is pretty sharp.\n\nShare with someon... usherald.com https://external.xx.fbcdn.net/safe_image.php?d... http://usherald.com/little-boy-asks-his-dad-wh... Sounds about right. with someone today. Source ... 2016-02-03T14:00:00Z 2016-02-03T17:10:22Z 2016-02-03 2016-02-03 2016-02-03T20:00:00Z 2016-02-03T23:10:22Z 167617.0 USHerald.com Media/News/Publishing media
119278 316913578439861 Abolish The IRS 316913578439861_748299538634594 link ‘Integrated’ Muslim Migrants Say Germans Are ‘... Footage has emerged that was shot inside a Ger... politicalears.com https://external.xx.fbcdn.net/safe_image.php?d... http://politicalears.com/2016/01/integrated-mu... NaN ... 2016-01-20T09:10:03Z 2016-01-20T11:46:27Z 2016-01-20 2016-01-20 2016-01-20T15:10:03Z 2016-01-20T17:46:27Z 234657.0 DailySurge.com Website group
126115 316913578439861 Abolish The IRS 316913578439861_748916458572902 link ‘Integrated’ Muslim Migrants Say Germans Are ‘... Footage has emerged that was shot inside a Ger... politicalears.com https://external.xx.fbcdn.net/safe_image.php?d... http://politicalears.com/2016/01/integrated-mu... NaN ... 2016-01-21T20:10:03Z 2016-01-21T20:10:03Z 2016-01-21 2016-01-21 2016-01-22T02:10:03Z 2016-01-22T02:10:03Z 211970.0 DailySurge.com Website group
128469 316913578439861 Abolish The IRS 316913578439861_748639565267258 link ‘Integrated’ Muslim Migrants Say Germans Are ‘... Footage has emerged that was shot inside a Ger... politicalears.com https://external.xx.fbcdn.net/safe_image.php?d... http://politicalears.com/2016/01/integrated-mu... NaN ... 2016-01-21T04:10:02Z 2016-01-21T05:21:44Z 2016-01-21 2016-01-21 2016-01-21T10:10:02Z 2016-01-21T11:21:44Z 228814.0 DailySurge.com Website group
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
116995 312531385450925 The Last Great Stand 312531385450925_1137614469609275 link Pepi Yes, you certainly have. \n\nAnyone else would... NaN https://external.xx.fbcdn.net/safe_image.php?d... http://www.americanpoliticnews.com/us-politics... Obama Family: “We Have Been Treated Unfairly W... ... 2016-10-16T09:14:01Z 2016-10-17T10:45:09Z 2016-10-16 2016-10-17 2016-10-16T14:14:01Z 2016-10-17T15:45:09Z 26931.0 AmericanPoliticNews.co Politician media
117644 312531385450925 The Last Great Stand 312531385450925_986922304678493 link Mad World News NaN NaN https://external.xx.fbcdn.net/safe_image.php?d... http://madworldnews.com/chris-rock-oscars-3-na... Although America is just getting over the raci... ... 2016-02-29T12:54:41Z 2016-03-02T07:54:29Z 2016-02-29 2016-03-02 2016-02-29T18:54:41Z 2016-03-02T13:54:29Z 24932.0 MadWorldNews.com Politician media
119691 312531385450925 The Last Great Stand 312531385450925_944249712279086 link Julie But don't worry... Obama says you have nothing... NaN https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2015/12/san-bernardino-t... Cruz demands the records...\n\n ... 2015-12-06T11:26:40Z 2015-12-06T11:26:40Z 2015-12-06 2015-12-06 2015-12-06T17:26:40Z 2015-12-06T17:26:40Z 13796.0 ClashDaily.com Politician media
120372 312531385450925 The Last Great Stand 312531385450925_937267812977276 link Obama Says Only 2% of Refugees Are Young Men, ... NaN usapoliticstoday.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.usapoliticstoday.com/obama-says-onl... The U.S. State Department says more than half ... ... 2015-11-21T07:22:12Z 2015-11-21T07:22:12Z 2015-11-21 2015-11-21 2015-11-21T13:22:12Z 2015-11-21T13:22:12Z 14197.0 USAPoliticsToday.com Politician media
121244 312531385450925 The Last Great Stand 312531385450925_1049670245070365 link BREAKING: Insider Leaks Secret Reaction White ... EXCLUSIVE: A political insider just released a... usapoliticstoday.com https://external.xx.fbcdn.net/safe_image.php?w... http://www.usapoliticstoday.com/breaking-insid... Exclusive information from a Washington inside... ... 2016-06-16T11:00:00Z 2016-06-17T00:02:32Z 2016-06-16 2016-06-17 2016-06-16T16:00:00Z 2016-06-17T05:02:32Z 6106.0 USAPoliticsToday.com Politician media
121399 312531385450925 The Last Great Stand 312531385450925_1058059437564779 link BREAKING: Large Explosions & Gunfire Rock Majo... It is absolute chaos ... usapoliticstoday.com https://external.xx.fbcdn.net/safe_image.php?d... http://www.usapoliticstoday.com/breaking-large... He been rocked by two separate explosions and ... ... 2016-06-30T10:00:00Z 2016-06-30T10:00:00Z 2016-06-30 2016-06-30 2016-06-30T15:00:00Z 2016-06-30T15:00:00Z 6106.0 USAPoliticsToday.com Politician media
129172 312531385450925 The Last Great Stand 312531385450925_937346906302700 link SIMPLE INTERVIEW QUESTIONS: For Muslim Syrian ... NaN clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2015/11/simple-interview... Here are my interview questions for the 97.5% ... ... 2015-11-21T11:11:53Z 2015-11-21T11:11:53Z 2015-11-21 2015-11-21 2015-11-21T17:11:53Z 2015-11-21T17:11:53Z 14210.0 ClashDaily.com Politician media
130763 312531385450925 The Last Great Stand 312531385450925_950664091637648 link SECOND AMENDMENT AMBASSADORS: How Gun Owners C... Take note of the gun slides...\n\nJust saying... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2015/12/second-amendment... Gun owners can play a useful role as ambassado... ... 2015-12-20T08:29:52Z 2015-12-20T08:29:52Z 2015-12-20 2015-12-20 2015-12-20T14:29:52Z 2015-12-20T14:29:52Z 13865.0 ClashDaily.com Politician media
132222 312531385450925 The Last Great Stand 312531385450925_938922762811781 link Mary Margaret NaN NaN https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2015/11/question-when-wi... I wonder when The Islamapologist-In-Chief ...\... ... 2015-11-24T11:02:09Z 2015-11-24T11:02:09Z 2015-11-24 2015-11-24 2015-11-24T17:02:09Z 2015-11-24T17:02:09Z 14210.0 ClashDaily.com Politician media
3723 721683147909323 The New Resistance 721683147909323_1298496370227995 link HEY, RIOTOUS SNOWFLAKES: The Grand Jury Just I... Keep breaking crap, dumb@sses! Look what await... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/hey-riotous-snow... Eight years of 'space to destroy' have come to... ... 2017-02-16T07:00:07Z 2017-02-19T09:51:00Z 2017-02-16 2017-02-19 2017-02-16T13:00:07Z 2017-02-19T15:51:00Z 212803.0 ClashDaily.com Community group
4643 721683147909323 The New Resistance 721683147909323_1296460493764916 link The PUSSIFIED NFL Threatens Texas – Gov. Abbot... I have three words for The NFL's 'mandate': Ki... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/pussified-nfl-th... It seems as though political activists have hi... ... 2017-02-14T10:04:55Z 2017-02-18T04:37:33Z 2017-02-14 2017-02-18 2017-02-14T16:04:55Z 2017-02-18T10:37:33Z 212803.0 ClashDaily.com Community group
12465 721683147909323 The New Resistance 721683147909323_1297902983620667 link DEAR P*SSIES: Here’s What Old People Mean When... Hey, parents! Show this to your kids clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/dear-pssies-here... Watch this comedian clearly explain what the w... ... 2017-02-15T19:00:01Z 2017-02-18T11:12:01Z 2017-02-15 2017-02-18 2017-02-16T01:00:01Z 2017-02-18T17:12:01Z 212803.0 ClashDaily.com Community group
21443 721683147909323 The New Resistance 721683147909323_1296981190379513 link WATCH: Pregnant Beyonce Hoofs Around Pretty Mu... GOOD LAWD! I swear she's looking MORE like Jay... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/watch-pregnant-b... Beyoncé struts around on stage pregnant in a g... ... 2017-02-14T19:00:02Z 2017-02-14T19:00:02Z 2017-02-14 2017-02-14 2017-02-15T01:00:02Z 2017-02-15T01:00:02Z 212803.0 ClashDaily.com Community group
22115 721683147909323 The New Resistance 721683147909323_1298496506894648 link WATCH: Travel Ban Protesters Asked WHY No ‘Ext... FULL. RETARD. ON. DISPLAY. clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/watch-travel-ban... Earlier this week, a bunch of students walked ... ... 2017-02-16T08:00:07Z 2017-02-24T19:07:51Z 2017-02-16 2017-02-24 2017-02-16T14:00:07Z 2017-02-25T01:07:51Z 212803.0 ClashDaily.com Community group
32549 721683147909323 The New Resistance 721683147909323_1296980153712950 link JACK@SS: Liberal DC Gym Owner ATTACKS Ivanka –... What a crock of Liberal crap. We've provided t... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/jackss-liberal-d... Was this illegal, or just immoral? ... 2017-02-14T17:00:06Z 2017-02-17T05:08:20Z 2017-02-14 2017-02-17 2017-02-14T23:00:06Z 2017-02-17T11:08:20Z 212803.0 ClashDaily.com Community group
37305 721683147909323 The New Resistance 721683147909323_1297351470342485 link PUSSIFICATION: Cops Shoot Burglar In The Ass –... What an ass-clown. This dude is DEFINITELY a l... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/pussification-co... We DARE you to find someone dumber than this guy. ... 2017-02-15T09:00:00Z 2017-02-16T15:48:19Z 2017-02-15 2017-02-16 2017-02-15T15:00:00Z 2017-02-16T21:48:19Z 212803.0 ClashDaily.com Community group
51429 721683147909323 The New Resistance 721683147909323_1297896930287939 link TOUCHÈ: After Teammates Boycott White House, T... Brady's post will NOT sit well with the SNOWFL... clashdaily.com https://external.xx.fbcdn.net/safe_image.php?d... http://clashdaily.com/2017/02/touche-teammates... Brady's Teammates were expecting to MAKE a sta... ... 2017-02-15T17:00:00Z 2017-02-17T17:35:30Z 2017-02-15 2017-02-17 2017-02-15T23:00:00Z 2017-02-17T23:35:30Z 212803.0 ClashDaily.com Community group
2389 21124264380 Trina 21124264380_10154757829119381 link Donald Trump Dead From A Fatal HEART ATTACK! -... Is this true ? fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/donald-trump-dead-from-a-... Donald Trump was pronounced dead this morning ... ... 2016-08-16T16:39:57Z 2016-08-18T11:33:24Z 2016-08-16 2016-08-18 2016-08-16T21:39:57Z 2016-08-18T16:33:24Z 11387471.0 FedsAlert.com Musician/Band others
6532 21124264380 Trina 21124264380_10154831534269381 link Donald Trump Dead From A Fatal HEART ATTACK! -... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/donald-trump-dead-from-a-... Donald Trump was pronounced dead this morning ... ... 2016-09-06T23:17:49Z 2016-09-08T06:55:37Z 2016-09-06 2016-09-08 2016-09-07T04:17:49Z 2016-09-08T11:55:37Z 9133508.0 FedsAlert.com Musician/Band others
9649 21124264380 Trina 21124264380_10154770977639381 link Man Spent Rent Money at Strip Club Then Tells ... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/man-spent-rent-money-at-s... “I told my wife that-that ass had me hypnotize... ... 2016-08-20T20:31:56Z 2016-08-21T06:48:24Z 2016-08-20 2016-08-21 2016-08-21T01:31:56Z 2016-08-21T11:48:24Z 11770348.0 FedsAlert.com Musician/Band others
10779 21124264380 Trina 21124264380_10154800981754381 link Man Spent Rent Money at Strip Club Then Tells ... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/man-spent-rent-money-at-s... “I told my wife that-that ass had me hypnotize... ... 2016-08-29T06:28:51Z 2016-08-30T06:48:42Z 2016-08-29 2016-08-30 2016-08-29T11:28:51Z 2016-08-30T11:48:42Z 8650308.0 FedsAlert.com Musician/Band others
11506 21124264380 Trina 21124264380_10154869766479381 link Donald Trump Dead From A Fatal HEART ATTACK! -... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/donald-trump-dead-from-a-... Donald Trump was pronounced dead this morning ... ... 2016-09-18T23:18:31Z 2016-09-19T03:06:49Z 2016-09-18 2016-09-19 2016-09-19T04:18:31Z 2016-09-19T08:06:49Z 14315460.0 FedsAlert.com Musician/Band others
12487 21124264380 Trina 21124264380_10154773218669381 link Man Spent Rent Money at Strip Club Then Tells ... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/man-spent-rent-money-at-s... “I told my wife that-that ass had me hypnotize... ... 2016-08-21T13:54:04Z 2016-08-22T08:34:44Z 2016-08-21 2016-08-22 2016-08-21T18:54:04Z 2016-08-22T13:34:44Z 11176121.0 FedsAlert.com Musician/Band others
21609 21124264380 Trina 21124264380_10154761668054381 link Donald Trump Dead From A Fatal HEART ATTACK! -... Is this true ? fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/donald-trump-dead-from-a-... Donald Trump was pronounced dead this morning ... ... 2016-08-17T23:06:42Z 2016-08-18T11:46:05Z 2016-08-17 2016-08-18 2016-08-18T04:06:42Z 2016-08-18T16:46:05Z 11387471.0 FedsAlert.com Musician/Band others
24214 21124264380 Trina 21124264380_10154792085564381 link Man Spent Rent Money at Strip Club Then Tells ... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/man-spent-rent-money-at-s... “I told my wife that-that ass had me hypnotize... ... 2016-08-26T19:44:35Z 2016-08-27T06:45:05Z 2016-08-26 2016-08-27 2016-08-27T00:44:35Z 2016-08-27T11:45:05Z 9314404.0 FedsAlert.com Musician/Band others
27168 21124264380 Trina 21124264380_10154792929674381 link Donald Trump Dead From A Fatal HEART ATTACK! -... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/donald-trump-dead-from-a-... Donald Trump was pronounced dead this morning ... ... 2016-08-27T01:25:10Z 2016-08-27T13:31:56Z 2016-08-27 2016-08-27 2016-08-27T06:25:10Z 2016-08-27T18:31:56Z 9274034.0 FedsAlert.com Musician/Band others
28726 21124264380 Trina 21124264380_10154783042464381 link Jealous Woman Drowns Trying To Get Cheating Bo... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/jealous-woman-drowns-tryi... “Too bad she wasn’t in a life proof case” Said... ... 2016-08-24T14:56:26Z 2016-08-25T07:52:06Z 2016-08-24 2016-08-25 2016-08-24T19:56:26Z 2016-08-25T12:52:06Z 9862829.0 FedsAlert.com Musician/Band others
38958 21124264380 Trina 21124264380_10154766774604381 link Retired Cop Selling R.I.P. Shirts of All Black... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/retired-cop-selling-r-i-p... “This is what they create when they kill each ... ... 2016-08-19T13:53:46Z 2016-08-20T01:41:28Z 2016-08-19 2016-08-20 2016-08-19T18:53:46Z 2016-08-20T06:41:28Z 11869579.0 FedsAlert.com Musician/Band others
46856 21124264380 Trina 21124264380_10154777184059381 link Surgeon General Warns that skinny jeans are le... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/surgeon-general-warns-tha... Men your knees should not show through your pa... ... 2016-08-22T19:35:47Z 2016-08-23T06:16:04Z 2016-08-22 2016-08-23 2016-08-23T00:35:47Z 2016-08-23T11:16:04Z 10111992.0 FedsAlert.com Musician/Band others
57141 21124264380 Trina 21124264380_10154788298319381 link Donald Trump Dead From A Fatal HEART ATTACK! -... NaN fedsalert.com https://external.xx.fbcdn.net/safe_image.php?d... http://fedsalert.com/donald-trump-dead-from-a-... Donald Trump was pronounced dead this morning ... ... 2016-08-26T01:19:12Z 2016-08-26T03:07:26Z 2016-08-26 2016-08-26 2016-08-26T06:19:12Z 2016-08-26T08:07:26Z 9104018.0 FedsAlert.com Musician/Band others

1466 rows × 24 columns

In [44]:
times = pd.DataFrame()
times = mainlyfromone_data.groupby('post_created_date_CT').mean()
times['count'] = mainlyfromone_data.groupby('post_created_date_CT').size()
times.reset_index(level=0, inplace=True)
times=times[['post_created_date_CT','count']]
times['post_created_date_CT'] = times['post_created_date_CT'].apply(lambda x:datetime.strptime(x,'%Y-%m-%d'))
plt.rcParams['figure.figsize'] = [25, 12]
mpl.pyplot.plot_date(times['post_created_date_CT'], times['count'],'b-')
Out[44]:
[<matplotlib.lines.Line2D at 0x7f7ba4ef6eb8>]